Yep. I think most recent Bay Area transplants got used to how clean and shiny SF was in the 2010-17 period, which was inherently an anomaly in SF's history.
It's always had a transient issue, and the high availability of support resource, the conversions of RSOs into hotels and airbnbs made visible, and the increased gentrification of SF (upper middle class white collar families didn't live in Mission, much of the SoMA-Potrero flatlands, much of Castro, etc until the 2010s) made these extremely visible.
Now that hybrid work has been normalized, I expect to see housing in the inner city (Tenderloin, Union Square) portion of SF to become significantly affordable, as those boutique hotels are returning to their RSO roots. And it already has based on the lack of rent increases with my former landlord's management company (all the 1-2 bdrms their renting out have stabilized in the $1500-2000/mo range in the inner city areas)
The city still has a lot of value in the tech ecosystem, but there's a reason the tech industry is called "Silicon Valley", not San Francisco. The gravity has always been in Santa Clara County, and always will be, but now San Francisco County has a decent bigtech scene as well (which didn't really exist there before the 2000s).