Many of our relatives who have lived in the Bay Area for years can’t believe where people are willing to buy homes up there now.
It’s understandable that affordability is the driving factor, but if/when things slow down again, they might have some challenges getting rid of some of those outlier properties, and, in the meantime, I don’t think the lifestyle is really be what you might call optimum.
It’s just my opinion that life is too short not to live the life you want to live, where you want to live it. We’ve known quite a few people who have waited for “retirement,” and never made it to that point, or found their time was cut short later in life, so–to the OP–find something you like, and start enjoying it now.