I'm talking nationally. There are going to be outliers you can cherry pick for local concerns. The national data is quite clear on this, reference any stats you want on FRED or otherwise
And those jobs in SF are likely to go remote in large part, as we've already seen a strong transition towards. It's not very economically efficient to make employment contingent on location, so I'm doubtful that will continue to be the baseline model for white collar work.
Home prices in the Bay Area are driven by local employment, yet I can take the same job now and move to Texas and buy a 300k house rather than 3 million. The amenities and culture will develop over time.
Doesn't seem to be a very favorable outlook
from a fundamental perspective for BA RE prices to me