I think the city is still great - there has been general doomerism about SF for literally half a century at this point: hippies, AIDS, the 90s crime wave, dotcom, gentrification, WFH. A lot of this is motivated more by what SF represents (the American brand of corporate liberalism) than what it is.

Crime is worse but not unlivably so. We have wonderful innovations like Facebook, Citizen, Nextdoor, and Ring to thank for the increased spotlight. While tech decamped from the Bay Area during the pandemic, and SF commercial real estate values are in trouble, plenty of companies are still operating here and people do still want to live here.

SF offers an urban lifestyle/environment you can’t get elsewhere in the Bay Area which draws young tech workers and hence companies. The crime would have to get much, much worse to threaten this. Others may chime in that it got too much for them, but this is a general trend as people hit their 30s and start families. The bigger threat is if young people don’t even give SF a shot at all.