This is one of the reasons I'm considering a move to SoCal, but I will never, ever consider moving to NorCal.
One thing I've heard is that SoCal is full of superficial, shallow, materialistic people, and that people in NorCal are expected to have a cause. It doesn't have to be a left-wing cause, either; look at Curtis Yarvin, for example.
I'm somewhat SJW myself, but really I'm a consumerist at heart. I just want to live in a cookie-cutter suburb, eat tasty food, watch TV shows I enjoy, hack on code as a hobby, etc. I would be very uncomfortable in NorCal being surrounded by militant vegans and Bernie Bros on the left and dark enlightenment people and physical-removal ancaps on the right. On the other hand, SoCal sounds pretty close to paradise to me (it's actually between SoCal and Vegas for me... I can't decide which one I'd rather move to).