Games Worth Playing - Miguel de Icaza
BioShock sounds like a good game... For me I am in a similar situation where I like games with a story...
IF those types of games are what you like the Halo Series is good, if you are just interested in stories, it has a great underlying story.
Prey is another fairly strong story game (still working through it though).
Gears of War is very interesting and the next game may make the story much deeper and see where the road takes us.
Knights of the Old Republic was good but is a bit slower since it is a RPG
God of War is another everyone raves about (don't own a PlayStation so I have not seen it).
The newer games like Lost Odyssey I have not tried yet, but there are lots with decent stories and it is just finding them in the noise of the other games...
Games Worth Playing - Miguel de Icaza