Fallout 3 ruined my life. I'd say games that are in that middle ground, and are quite difficult to describe really make me think Killer7, Eternal Darkness and Indigo Prophecy are a few examples. Deus Ex is another one of my favourites, I don't really think I can stick to one type!
[SIZE="3"]Hail to the King, Baby.[/SIZE]