I could mention a few, like the orphanage in Thief, or the Ocean house from Vampire:Bloodlines (though that part is pretty much stolen right off 'the Shining', it's very well executed). The first time I saw the father in the boiler room I freaked out and had to call a friend who had finished that episode already, under the guise of him "helping me finish it". Yes. I had to call a friend.
There's actually one other game that completely scared me senseless, though I doubt anyone of you will have even heard of it. It was back in the mid 90's before the IT-bubble burst, and EVERYONE and their mother was making games. You know, back when they called it Multimedia. In 1997, ARLA, a Swedish-Danish dairy industry, commisioned some obscure studio to make a game for them, a game that was supposed to create interest in the company, the life of a (modern) dairy farmer, and to spur PR and goodwill.
It was called "Myulk". (Pronounciation is similar to the swedish word for Milk, and this twisting of the word already heralded the things to come)
It was terrifying. The player inherits an old run-down dairy farm and has three years to make it profitable. The latter part of the game is simple, but decent enough management. The problem is the first part, the "adventure-mode". This first part of the game has Myst-like graphics and interface, and you explore an abandoned farm, overgrown with strange black weeds, while ominous weather rolls overhead. This part of the game is smock-full of horror-movie elements, like when you look through a telescope and something suddenly appears very close in the viewfinder, followed by an unhuman laughter. Keep in mind this game was aimed for people about the age of 7-14. It turns out that the farm has been taken over by (yes I'm serious) an evil root with the name of Slymmer, and you must fight him to regain control of the farm. The music, and the atmosphere of this game chilled me to my core when I was a kid, and when I found it online a few months ago, I was shocked by how scary it was still. More than anything else though, I have never before or since felt so alone in a game...you know, almost alone. The worst kind, made painfully clear by the sign at the bus-stop: "The bus arrives in five hours".
Post edited July 02, 2009 by Isamael