"Alejandro" has her character as dressing white, saint like robes; depending on who you ask, she was meant to represent the Don't Ask, Don't Tell policy (although, depending on how you feel about that, she might be your hero). And the infamous ending had her face melting away while her eyes and mouth were replaced by light; many will be glad to inform you of how terrifying that looked.
Pepe Deluxé's Queen of the Wave. It's spelled out in the liner notes: the song "A Night and a Day" is "a poetic synopsis of Mainin's (whose name means 'light') first steps to becoming a light adrift on the seas, a lure to death for all those who followed him."
Rammsteins "Hier kommt die Sonne": "The sun is shining out of my hands/ Can burn, can blind you/ When it breaks out of [my] fist/ Lays itself hotly on [your] face" ("Die Snne scheint mire aus den Händen/ Kann verbrennen, kann euch blenden/ Wenn sie as den Fausten bricht/ Legt sich heiß auf das Gesicht")
UNICORNS FROM HELL. Unicorns still have their "heavenly" look, but they're appearently nazis now.
The general message of Marilyn Manson is half this, half Dark Is Not Evil. Even the original Theme Naming was about this. The first half of the names was taken from a female sex symbol, and the second half from a convicted murderer. As Marilyn Manson himself said, Marilyn Monroe had bad qualities about her, and Charles Manson has good ones about him (environmentalism, for example). We see only the badness in people we're told are bad, and only the good in people we're told are good. Much of the band's songs and videos highlight these subjects, ranging from the video for Dope Hat's even darker take on Willy Wonka & the Chocolate Factory's boat scene, to Coma White, a song about suicide by OD, to the entire character of Omega (pronounced oh-me-ga) from Mechanical Animals, who is completely white as paper besides for his hair and makeup (and sometimes even his hair is white), but is a dead inside rock starandrogynous space alien. The Unseen, Alpha (also called Mar1lynMan5on due to Manson's obsession with 15), meanwhile, is a hopeless romantic, who is the other protagonist of the album and sings the emotional songs on it. Manson himself, although dressing in all black most of the time, and covered in tattoos, is an intelligent, Deadpan Snarker who often shows that, despite his shocking image, is actually extremely laid back. His closest love in the world is his pet cat, Lily White, who he considers his child.
The Spawn of Possession song "Apparition" has the titular angel who appears as a being of light, who convinces the father of a family to murder his wife and daughter. It later reveals itself to be a demon as it takes his son away.
The Avantasia song "Wake Up To The Moon": The lines "Follow your heart and run/ Seek shelter from the day" and "Child of the ocean floor/ No need of daylight that deceives you" in particular.