Bioshock can be pretty long or really short depending on how you play. If you take your time exploring and collecting all the Little Sisters, it should last awhile.
This can basically be said for
Fable as well. The story is quite short, but there's a lot of fun to be had doing all the optional stuff (i.e. finding all the unique weapons, etc.).