So, SF is not a clean, beautiful, and safe city, considering that the part of it with all the interesting stuff also happens to be drowning in a putrid combination of feces and needles.

It's just like saying that Earth is a lovely place, as long as you avoid breathing the atmosphere and drinking any of the water. Look at the forests! Hope your spacesuit's faceplate doesn't become pitted by the acid rain.