The homeless and those issues pretty much only exist in the tourist areas near downtown, the tenderloin, soma, etc. The tourists come and see all of that and get the idea SF is some horrible dystopia, but unless you live in those areas, it's not a problem. I lived in Noe Valley for 3 years and never ran into a single problem from your list. SF is so much more than downtown.
As long as we're giving personal anecdotes, I lived in the mission (the "good side" near dolores park) for 8 years and experienced most of that list. I was physically assaulted last fall while walking back from Noe Valley at 2pm in the afternoon. Nobody answered the police non emergency number while I followed the assailant (who threw a right hook that I only partially dodged as he walked past me on the street).
Sure, you get better at dodging feces and ignoring the drug use, littering, and theft, but let's not pretend it's confined to "downtown, the tenderloin, soma, etc".
I've lived and worked in Manhattan and DC, and spent time in many international cities. I've walked all over all of them, and never felt less safe than I regularly did walking to work in soma.
SF has a unique political situation, a climate that makes homelessness "bearable" and a huge number of absentee landlords (thanks, Prop 13).
We were sad to move out in January. SF is a gorgeous city filled with kind, interesting people. "Horrible dystopia" is certainly an exaggeration, but the situation is bad and has gotten much worse in the past few years.
There are homeless encampments and tents on streets in the Marina district now, so these issues aren't isolated to "tourist areas".
Yes, some parts of the city definitely have it worse than others, but I don't think it's fair to dismiss these issues on the basis that there are small residential enclaves that are less affected.
If you want to enjoy SF's restaurant scene, nightlife, hiking, etc., you will inevitably have to go to areas where this crime is rampant. And this crime should not be happening in an American city, let alone one that is so rich.
The "bad / dangerous" part of the city is now significantly larger than it was even three years ago, when you moved here. It's been expanding rapidly the past few years.
Can confirm. In general, unless you actually step into them, human feces are not a problem. Just watch your step and be alert. How difficult can it be?