In honor of Hallowe'en, Rolling Stone has a feature called Monsters of Rock- Bands That Scared the Crap Out of Us. Of course, there are links to my man Marilyn, and also Slipknot, Rob Zombie and some other ones.
Personally, I was always more scared by this sort of thing. >shudder<