Please don't list this on a work's page as a trope. Examples can go on the work's YMMV tab.
Nightmare Fuel: Within Temptation
"Say My Name" is this and Tear Jerker simultaneously due to being about a child lamenting that their Alzheimer's-stricken parent can no longer remember the child's own name.
The lines: "I'll make them bleed at my feet" and "One by one they were surprised" from "The Promise" count too, especially cause it strongly sounds like she is singing the latter with a smile on her face.
Potentially the comic books and short films that accompany The Unforgiving. For instance, the first of the three films features three apparently cannibalistic children. The children are revealed to be the Triplets, created from Mother Maiden reviving the deceased corpse of a young boy with split personalities due to being sexually abused by his father.
Try playing "Intro" from Mother Earth set to repeat itself. In a dark room , maybe the random voices in the background start making sense.
The video for "Frozen" seems to be a story of a mother killing her abusive husband to protect her daughter. Then Sharon picks up the doll the daughter broke after she was abused.
Play "Our Solemn Hour" reversed and use your imagination while listening.