I too really like
Heroes of Horror. But then, I've always felt that the line between standard dnd and horror dnd is very thin- looking back at the ol' 1e FF, especially the penangellan, I've always had a soft spot for horrific encounters and gruesome monsters. I loved
the Gates of Firestorm Peak and dubbed it "most Cthulhu dnd adventure evar" (I even plan a
Return to the Gates of Firestorm Peak for my game eventually).
The best part of HoH for me was all the dm advice on mood, different types and techniques of horror, etc. Overall, it is a great book (imho)!
I'm glad that a gronard such as BroccoliRage can get so much enjoyment from it!