I actually found The Lost Crown very scary the first time I played it and had to stop for a while before I worked up my courage to get back to it.
I'm easily affected, I suppose.
Now, since I know everything that's coming and have played it many more times, I've mellowed on it considerably, so any sequels are probably going to throw me for a loop, seeing as how I've been lulled into a "false" calm.
Actually, when done right, I far prefer vampires over zombies. The TV show, Buffy the Vampire Slayer handled them very well, at least as far as characterizations were concerned. A writer can do a lot with vampires, as they have very long histories, which can lend itself to a lot of character complexity, as opposed to zombies, who just walk around, make zombie sounds and eat people. Not a lot going on there.
The Walking Dead games are an exception to the rule for me, and it's because of what's going on around the zombies that it works so well for me. I haven't really seen a game get vampires right yet, though. Even one of my favorite games, Gabriel Knight 3 didn't work as well as it did because of the vampires, which were not very well developed at all, but because of its great in depth plot as well as its focus on Gabriel and Grace's relationship. Also, there was the fantastic Le Serpent Rouge puzzle.
I am in agreement with you on how interesting ghosts can be though, BubbaJake, and I think The Lost Crown did a fantastic job with its ghosts. Each one has an interesting story behind it; they aren't there just to scare Nigel, who's really pretty stoic anyway. I couldn't believe all the things he remained unaffected by.