It's tolerable if you're a just out of college bachelor/ette, but if you want to have a bit more space (let alone a family) you pretty much have to leave unless you've gotten rich. Even for young people if you do the math your big Bay Area salary actually doesn't get you ahead as much as a slightly lower salary in a much lower cost of living city. Your whole paycheck goes to the landlord.
A secondary factor caused by real estate hyperinflation is that all the stuff that once made the SF Bay Area so interesting has been priced out. I remember the Bay Area in the 1990s. It was a hub not just of tech but of art, music, and culture. It was a magical in a way that's hard to explain today, and I say this as someone who only visited. My main experience of it was from the culture and "vibe" it exported. All that is gone now. It's a glorified office park. Why spend so much to live there if it's no different from any other city?