Can’t decide where to live in California

My partner and I are looking to move from DC to California and we are really struggling which cities to live in. Specifically, we keep going back and forth between San Diego and the Bay Area. I am a nurse, and she is an architect, we don’t have any kids. The main con with San Diego for us is the lack of rain. We both enjoy having rainy days and apparently Southern CA gets none of those. Sunshine every single day of the year would get old. Is the Bay Area that much more expensive? Any other ideas for towns anywhere else in CA that get good rainfall, lush/green scenery, access to hiking and beaches, and jobs for us both?

Edit: We do NOT want to live in any downtown areas, completely fine with suburbs and metropolitan area.