Have you tried The Walking Dead yet? I finally got around to trying it recently, and, although I've only played the first hour or so, it seems really good. I've also yet to hear a negative opinion on it. Not sure if it really qualifies as a horror game though.
I'll skip that one. Zombies don't interest me much at the best of times, and they're so ridiculously overplayed now that just seeing a zombie's almost enough to make me avoid something.
Zombies, werewolves, and most particularly vampires need to go away for about ten years. Of course, if they do then someone will probably find some way to ruin Lovecraftian abominations.