IF I was sure that my job was secure, I'd do it in a heartbeat. I'm from SoCal. I've lived in both LA and Orange counties. I have a heart condition which is exacerbated by stress. When I finally pulled the trigger and moved to NorCal, I noticed that everything was just a bit more relaxed. Even freeway driving was easier by comparison. (Not easy, but not as insane as SoCal.) As my stress level eased, so did my need for medication. My (new) cardiologist and lifestyle weaned me off of it completely. That was over twenty years ago. Same job, BTW, just different location.
I was just in SoCal last month for a family reunion. I don't regret my decision for a moment. FWIW, I live in the East Bay, where we have sunshine almost every day and just enough fog overnight that we generally only use the A/C about one week per summer. So far this year, it has been on exactly Zero times.
That said, I would not live in SF proper*. Too fucking crowded, not enough sunshine or parking and the RE balloon feels overinflated, IMO. Anywhere else in the Bay Area, I'd be surprised if RE prices were significantly different than OC. I also found it much easier to make friends, as people were much less guarded.
*Yes, I've lived in The City proper before. Had a sweet living arrangement in Noe Valley. Was there on a four-month job assignment and company let me rent a house that came complete with a private garage! I missed the sunshine too much, so when I moved up permanently, I headed east for the technicolor days. Oh, and the Open Space here is beyond compare. I can be out on an open trail in five minutes by foot. That's been true of all three houses I've owned here so far. It's part of why RE is so expensive, because a lot of acreage has been deeded as Open Space. The breathing room is incredible!
+ $1000 for living as close to work or light rail as possible.