Dead Space was awesome.

Doom 3 was a pretty scary game, played at night on my computer with headphones, jumped a few times on that one.

Clive Barker had a pretty good one - Undying.

And also Painkiller had it's moments.