If remote work holds up I expect to see San Fran's real estate market, at least it's rental market collapse
San Francisco's climate, walkable hoods, having a ton of things to do will probably make it come back from the dead even if the tech industry were to actually leave.
Events and opportunities to socialize.
Even if I have a family one day, I still would want my kids to take language classes , etc.
I hate driving ( particularly when commuting), so a town wouldn't really work.