I still say it has nothing on System Shock 2. Those spider things made me freak the hell out when playing, I was covered in goosebumps while fighting them. And the game actually had something more than point and shoot to it. A lot more. O_o
Doom 3? Nothing remotely that close on terms of scariness or fun...