The framework is clear. The bay area has, is and will likely be the best returning geo over the long term. But the barriers / cost to participate are very high. This area does not need some artificial impetus like a "pandemic" to prop its prices up. That IMHO is like a steroid shot for some geo's outside fo the area but lord knows how sustainable it is.
Barriers to entry are high but there are always deals available and that takes a whole lot of time and effort. But I feel it is worth it. The short cut is to pick an inexpensive midwest town and buy 3 properties or 7 and tell your friends you own so many units.
Sure that could work as well but it will come with its set of pros and cons. Appreciation will be a question mark and plus the burdens of managing properties remotely. The bay area on the other hand has always surprised me. I have listed expensive large properties thinking darn who would rent this when I am asking five figures. Then I get this barrage of calls from expats, companies moving execs, people going through home renovations, people moving from overseas etc and the home is rented in 3 weeks!! Such is the power of the bay, the demand here is very strong and solid. Again barriers to entry are steep but finding tenants and getting a nice fat rent check is very possible.