The Haight isn't that bad, I certainly wouldn't call it a red light district. I lived a block from Haight and Ashbury for a year, and while the fauxbos can be annoying they're mostly harmless.
Tenderloin is much scarier. My friend got punched in the face by a random guy walking down the street.