I remember playing Nocture some years ago. It was not a very well made game, but it would be a great movie. It was scary.
One that came to my mind was Alien vs Predator - the first one had some cool stressful situations

Because I'm a big Star Wars fan, I have to say the Star Wars Force Unleashed was a preeeeetty preeeeetty big disapointment.

I still remember when I've noticed the giant leap on the AI, when I started playing the first Half-life. Those soldiers where really smart at that time, by making their ambushes and avoiding fire and grenades.

Believe it or not ... Broken Sword - The Shadow of the Templars. And it is great :)