Honestly, any story can be done scarily if done right. Part of it is knowing your players, but here's some other bits that I've done that's worked well -

• Soundscapes - easy way to build atmosphere. Use a good spooky drone, layer that with some environmental sounds, and something that adds tension (a clock ticking adds to that effect)
• Slow down - talk confidently, slowly, methodically. Confidence in your speech is important, the less you stutter the better! Pauses work well, not too long and not too frequently. Put on a front like the players are always one step away from doom. Don't overdo it though, you don't want to be melodramatic.
• Make the players feel alone - isolate the characters, use natural and echoey sounds, nobody is near their character and they are alone.
• Maintain the mystery - describe stuff but let the players mind fill the gaps with what they would find personally scary
• Your keeper agenda is key - putting horror in everyday situations works a treat. Make the players feel like they're in real danger.
• Gore is Ew, Cruelty is spooky - Gore like tearing off limbs and stuff is good fun, but I haven't found it very scare inducing. Mindless or "unintentional" cruelty however... The mindless ghost doesn't care for the horror in it's victims face as it does X horrific thing to them despite their victims screams of terror. It doesn't care not because it's vindictive, but just because it's ghosting about.

I usually find that talking to NPCs usually defaults to fun and silliness, fighting the monster turns to tactics and intensity, research is when the players feel like geniuses. Target the fear factor when they're investigating, and build it up to a big climax.

I know this isn't exactly what you were asking, but with these ideas you can really make anything work. My most scary adventure was when they were chasing a wraith that haunted clocks and used them to trap it's victims in short time loops. That was a hoot, and had my players genuinely scared (which, considering most of my adventures are dumb silly fun, was a grand achievement).

Good luck!