My favourites are the Tomb Raider games, including the most recent, excellent, reboot of the series. They led me to the Uncharted games (kinda similar to TR, but with a male protagonist). And now my daughter has gotten me hooked on the Assassin's Creed games (currently about 65% of the way through Assassin's Creed II Brotherhood).
I don't play scary or spooky or survivalist horror, I much prefer adventure with a chunk of combat thrown in.
Hope that helps too.