I've lived in the Bay Area for 15 years. Except for the "poop on street" part, I've never witnessed any of those other things in SF or anywhere else either. I've never ever been threatened by anything (words or physically) in real life (this is true everywhere I've lived: Hong Kong, Florida, Connecticut, Texas, SF/Bay Area) In the Bay Area I've largely stayed in the less crowded suburbs such as Mountain View, Palo Alto, etc. where things are kept absurdly clean and orderly (the parks are hosed down at least once a week). Last week while going to work in Burlingame I did see there was human feces in the parking lot but the city sanitation worker was already cleaning it up. I do go to SF sometimes to see friends, to go at a restaurant (in pre-COVID times), etc. There is a small part of SF that gives me uncomfortable feelings but the rest of the city has never given me any issues and I've run through parts of the city in the middle of the night (during the Golden Gate Relay).

I'm not saying that it doesn't happen or that people who write about them are being untruthful. However, I do wonder if it is the extreme events or experiences that get written about and aggregated into news.