I have played some scary stuff, and by far the Ocean House Hotel from Vampire Bloodlines takes the uber cake. I can't think of anything scarier. That level is THE best level I have ever played. At first, I was so scared I had my friend play it for me, then my sibling, and then I finally attempted it. The atmosphere they did with that level is absolutely incredible. Nothing else compares to the atmosphere in that level. Mind blowing.
It's kinda funny. I got into the game not expecting it to be scary, and then I got to this level. I stumbled in, thinking it was a standard quest. I approached the door to the mansion, and the lightbulb explodes to my right. That unnerved me quite a bit. I entered and the chandilier falls from the ceiling. Strange level.... I then explore the hallway to the left which ended in a dead end. But then I heard a voice behind me. I flicked my mouse around to see what was there, and BAM there is the killer staring me in my face before it disappears. Stupidly, however, I kept going. I crawled up the staircase to fall through the floor. Now I was in the dark basement. I proceeded on through the basement, gripping my mouse, and leaning away from my monitor. Once the ghost girl skittered past me at the intersection, and then soon after disappeared, I had hit the ESC key, and exited the game completely. This was some scary stuff. Thought I would share.
Another part of the game that I felt had great atmosphere was the museum raid and the original sarcophogus level on the boat. What happened on this boat? Something very very bad.
The graphics in this game are incredible thanks to the source engine. The facial animations are absolutely breath taking. Incredibly realistic. There was on part in the Ocean House Hotel, where the room fades away, and you are standing outside. Out in the distance there is a rotating lighthouse beacon, shining through the burnt out room. Breathtaking. The music/sound is well done as well.
Scarier than Resident Evil and System Shock 2 I think. The game as a whole is also awesome. My favorite game of ALL time is Deus Ex. I have played Deus Ex 2 times through, and have completed Deus Ex Invisible War as well. This game reminds me so much of Deus Ex. The modern punk atmosphere. The action/RPG/FPS blend. Incredible. It's sad that so few games fill this genre gap. There are only 4 action FPS RPG's like this. Deus Ex, Deus Ex IW,System Shock 2, and Bloodlines. Thief kinda fits....but it doesn't have the skills. Can you guys think of any more?