Mid term (2-5 years) it seems like it would be optimal for Twitter to leave SF. Downtown isn't that great to work in and the Elon hate is red hot. They could still keep their SF employees as a satellite office. Bailing on what is surely a very pricey lease is an attractive bonus :-).
Though, it would be hilarious if Twitter's no work from home policy lead to downtown revitalization :0).
I still think SF has a lot to offer startups, but it's no longer essential. Talent has scattered a bit and work from home will continue to drain people away.
Also you probably want to run content moderation from somewhere a little less lopsided ideology-wise. A little more normie like Salt Lake City, Phoenix, or Austin. Ideally a content moderator should be able to have a civil lunch with 80% of the country.