I used Faery's Tale to run a Christmas one-shot (everyone played Christmas elves, tin soldiers, reindeer, etc.) for a group of adults and it played beautifully. For a game with more story than combat, I think it works admirably.
You might also consider Dread, which is designed as a horror game...