The last game that terrified me to the point of not being able to play at night was Clive Barker's Undying.... DOOM 3 is scary...but not as much.
It's enough to make me slightly jump, skin crawl, goose bumps, increase heart-rate...but not stop playing to turn on the lights sort of freaky.
Frightening situations...the hell cherub things...fighting a monster, backing up into another...and other things.
The point is, those of us who played Undying (
http://www.penny-arcade.com/view.php3?date=2001-03-09&res=l) or System Shock have been tempered...we've already played an incredibly terrifying game. DOOM 3 could be that for us...but our game terror virginity has been stripped.
-Azrael
"Don't Fear the Reaper, fear ME."
Decade of Death (A tribute to FPSs)
http://files.filefront.com/3197804;/pub2/Doom/Media/Videos%20and%20Trailers/http://files.filefront.com/3325050;/pub2/Doom/Media/Videos%20and%20Trailers/
-Azrael
"Don't Fear the Reaper, fear ME."
http://gamershots.net