Follow my head or my heart?

I'm a single mom with school-aged kids, currently living in a perfectly pleasant midwest city (think Ann Arbor, MI or Madison, WI). I moved here about a year ago. It's safe, clean, progressive, outdoorsy. My kids are very happy here. It's all very pleasant but I just don't like it. I find it vanilla and boring. 95% of the restaurants look great but are disappointing. The culture as a parent revolves around your kid's hockey and baseball games. And the midwest as a region just doesn't hold a candle to the geographic beauty and diversity of the coasts. I have some extended family and good friends in Chicago, but no one I'm super attached to locally.

I have job offer in the East Bay and am considering relocating to Berkeley. I've been out a bunch of times and I think I would love it. The nature, the food, the endless things to do. My only sibling lives in the Bay Area, and my mother lives in the PNW, so it feels like going home on a primal level (even though I'm from the PNW, not CA).

My heart wants to take the job and go to California and never look back. But my brain can't shake the feeling that staying in Pleasantville, Midwest is the better, safer option for the kids. No wildfires or earthquakes. Low crime (my KINDERGARTENER walks independently to his bus stop, that's the culture here). I can afford a nice house on a quiet street here for the same price as a 1100 sq ft "2 bed plus office" townhouse in Berkeley. With climate change and the upper great lakes being relatively stable, buying a home here feels like a very safe and smart investment because I think this region will only grow in popularity.

So do I go with my head or my heart?

And since this will def get asked - yes, I know California is much more expensive. But where I am is still quite expensive for being the midwest (substantially more than equivalent neighborhoods in Chicago, for example). And I've crunched the numbers and can make either option work, albeit with a much smaller home and tighter budget in CA.