I remember hearing Lou Reed performing "September Song" on some CBC Kurt Weill special in the early to mid-90s. It literally made me scream in horror and turn the TV off. One of the worst things I ever heard.
But Heroin is a pretty good song. I don't think I ever need to hear it again, but it's pretty good. Stephanie Says is awesome.