Half-Life 2. Suffering from a caffeine-high, late at night by myself, and really getting into the story, and then BOOM Ravenholm. Just the part where you're walking through, and there's nothing but a few bodies hanging from ropes and sawblades stuck into walls is the scariest thing I've experienced in a game.