Rose Red is such a deliciously terrifying haunted house story, how could I not think of it? True story, that song played over the speakers at my work once, my head snapped up so fast and I was genuinely creeped until it was over. Kinda like the time my roommate sang "Non Je Ne Regrette Rien"...

Yes, definitely such a trope. :)