I'll give some more love for Night of the Walking Dead. It's one of the few modules I've run more than once and it went down well every time.
Others I've enjoyed are:
Night Below - Ran this twice now, never finished it on either occassion, but it provided so many memorable moments for two groups of players.
Dragon Mountain - Ran and finished this once, and have cannibalised maps from it as well for another campaign as the mountain makes for a truly kickass stronghold.
Dead Gods - Never ran this, but reading it is a joy. Maybe someday I'll get around to running it.
Children of the Night series - I mean each book had 13 mini adventures themed around Vampires, Ghosts, Werecreatures and The Created. And demons too if you got the free download off the old Kargatane website. An easy way to add a touch of horror to any campaign.