Which reminds me, I have AvP 2 and Clive Barker's Undying lying on the shelf. Celtic action horror and dystopian scifi madness galore.
I've been hearing good things about Condemned, but i wasn't really hyped when I played FEAR and so am rather doubtful. Heh, Monolith is a great team and I usually trust their vision of quality(NOLF! Shogo!), but I might have to pass the game.
Shalebridge cradle should have been on that list, it has only one fault(the end of memories, when you go in yourself, the staff is easy to dispatch and not scary at all) and even that can be overlooked if you are one of the people who like relief at the end of scary levels.
As for SS2, I still haven't played it.
Edit: Thief:Dark Project, anyone? Pretty ****ing awesome game and absolutely horrifying undead levels.
Edit2: Hello, biggest ****ing scare of the decade, discounting the moment with the decapitated mannequin in Silent Hill 3: