Please don't list this on a work's page as a trope. Examples can go on the work's YMMV tab.
Nightmare Fuel: Velvet Underground
"Heroin" is a great way to unwillingly raise your heart rate, gain paranoia, become short of breath, feel like a needle was just jabbed into your arm...
If you need to be scared of Lou Reed, look no further than White Light/White Heat. "The Gift" wherein likeable hero Waldo mails himself to his long-distance girlfriend out of loneliness and fear that she might be cheating on him (fears which are proven right), when he gets there his girlfriend and her friend can't open the box he is in, so they get the cutter... Also Lady Godiva getting a lobotomy, yeah.