The scariest game I have ever played is the original Alies Versus Predator throughout the Marine campaign. You are literally crapping yourself throughout the entire game, with eerie silence save for the dripping of water and the steady pulse of your scanner. Occasionally you'll hear a door banging in the distance or a spooky pitter patter of feet in some nearby vent shaft or corridor.