The hotel?
The hotel's pretty crazy. The rest of the game isn't all that scary. The
has potential but it's too damn hard. After running down the same hallway fifty times I'm no longer scared, just annoyed.
Running down hallways while being chased by some sort of monster, I can only hear it, but I don't want to turn around all the way to see it because I know it will kill me.
Turning back just enough to close and lock the doors behind me.
I'm not sure which is going to kill me first, the curiosity or the monster. So I stop. And I turn around.
And I see a giant green... wall rushing towards me.
And I think I hear a sputter or a gasp, or maybe nothing at all.
What the fuck.
I just suffocated to death inside of a shoggoth.
The hotel scene was really intense too even though it was obviously trial-and-error that you could only win after going through at least two dozen times. The whole rest of the game is pretty uninteresting, especially after you get guns and the adventure-y aspect of the game pretty much melts away. I got about halfway through the very last level and never even finished it I was so offput by the drudgery of the everyday shooting bangbangness.
Were you playing on 360 or on the PC port? The PC port had engine issues where your movement speed was tied to your framerate...on a lot of machines, the hotel scene and the final sequence were nigh on, if not completely impossible without a trainer program to increase your movement speed. It really killed the tension of that scene and made it frustrating rather than scary. Other than that, it was a decent game, pretty scary, and I give it credit for some good concepts.
A lot of the best scary games I've played have been mentioned here already.
Amnesia was pretty freaky, and nicely paced between puzzle/tension/"OMGRUN!" scenes.
System Shock 2 had good amounts of tension while sneaking around the ship.
FEAR I found pretty scary, but Japanese "little girl" type horror tends to get to me. For some reason, Vampire: The Masquerade's hotel level didn't get to me though; I think it was because I realized fairly early on...
that it was all jump scares, with nothing to get me.
One I haven't seen mentioned yet is
Thief, incidentally on the same engine as
System Shock 2.
Thief was the first M rated game I played, and the Bonehoard, the Old Quarter, and the Cathedral were incredibly frightening at the time. The Cradle from
Thief 3 also did a good job with scary atmosphere.
KG