Bioshock

Definitely one of my favorite single player games ever. If you play any video games at all and haven't played Bioshock yet, I recommend you give it a try.
There's a Bioshock 2 teaser website up to anyone who's interested. As of now the sequel is scheduled to be released this year in Q3