What made SF interesting was pushed out long ago. What's left is an insular monoculture not unlike Cavendish bananas. Unless you've got deep roots there, seriously consider the alternative.
Everywhere else has less monoculture than SF. So just anywhere else in the US. Don’t get me wrong, SF is cool and an easy place to live with the weather and the parks and density level. But the people are as bland and similar as you can get.
Walking around the city you see a lot of commercial real estate signs and for lease signs. Tons of companies and individuals are leaving for good.
If the trend of WFH (forever) continues the rent prices in SF won’t go back up for a long time.