I'll grant your "expensive places to live" list is more than just the Bay Area.
As for "anywhere else"...pick your poison. Don't like hot weather? Texas isn't for you. Don't like cold weather? Northern states aren't for you. Want affordable living? California isn't for you. Whatever, everybody has something they don't like about every place.
As for "stuff to do," most people don't realize that Houston's Theater District is second only to Broadway in terms of theater seats. https://www.visithoustontexas.... It has a thriving nightlife and is a top destination on the restaurant circuit, and numerous pro sports teams. Its Galleria Mall is the 5th largest in the country, for those who like to shop. If you can't find something interesting to do in Texas, you aren't looking.
It's true, Ercot failed to keep the electricity on when Texas experienced its worst and longest freeze in 125 years. If California had its worst rainstorms in 125 years, it too would suffer extreme damage (sound familiar?). But wait, it only takes a *regular* summer in California to spawn thousands of wildfires. Again, pick your poison, every place has its issues when it comes to weather and natural disasters.
If you are just talking about affordability and jobs, yeah, Texas has a lot to offer, with 4 metros in the top 11 largest in the US. Each has excellent levels of employment in all kinds of sectors, from tech (Austin) to NASA (Houston) to medical science and genetics (Houston) to banking (Dallas). There is a niche for pretty much everybody. Each is quite affordable compared to other major metro areas in the country, none of which appear on your "most expensive places to live" list.