I agree there are some terrible policies and parts of town are struggling (and addicts too). But there were huge problems in the 90s as well (in SF an NY). Frankly, NYC is a MUCH bigger place with Manhattan alone being twice the population. But please, if you don't like it LEAVE!
Nobody likes poop or needles, nor drive-bys and side-shows those are symptoms of law enforcement and the city not giving a F#ck... but the tenderloin wasn't some beautiful panacea 25 years ago either, nor the mission, nor the dog patch. All of those places were hipster-gentrified and drove out people who did give a damn. Bringing money doesn't mean that a WETF attitude and boring consumerism won't make the place worse than you found it.
If you want to raise kids, go to the avenues or the marina or a suburb somewhere. Yes, it's horrible expensive, but why does the world owe you the lifestyle you want and the house you want in the place you want for cheap? Why does everyone else have to change the way they live for you? Because you got a FAANG job? I feel more for the people born in SF.
BTW we always called the Fidi "wine country" for the obvious reason (people drinking wine on the corner)... and that was 25 years ago when at least strip clubs could afford the rent.