I'm a recent transplant, too. But I live in SJ, unfortunately. I do think it's like living in a hell hole.
Like what?
I've lived in SF and SJ. I still currently live in the Bay Area. I've lived in various cities in Southern California and Oregon. I've also lived abroad as well.
Every place I've lived in had some good and bad. The Bay Area is no exception. I always thought I'd prefer LA over SF and the Bay Area, however, in recent years it's begun to change. I always thought SF didn't have anything except for people who loved to go out to restaurants and hole-in-the-wall type food/bar/night life experiences. In that regards, SF is amazing for having a lot of attractions in any given area. However, I personally don't really care about these places.
I think the Bay Area is amazing for everything that most people don't go to. I think most people here just go to work, come home, and spend time with family or friends. Maybe they'll stay home and watch Netflix or go out to a bar or restaurant with friends. That's it.
However, they are missing out on a lot of the sights, scenery, and areas around here. In recent years I got into cars and having cars that I love to drive, I eventually wandered off the beaten path to go to different festivals, different cities I never spent time at, I went on mountain paths with gorgeous views of lakes and the Bay Area, restaurants on mountains, backroads down to Gilroy that is hidden from the 101 or highway 1, etc.
There are so many places to go and explore in the Bay Area that people just don't go out and do. Everyone will hang out in certain areas like SF people only stay in SF or SJ people only stay in Downtown SJ, but if you find yourself loving to drive, then get out there and drive around. There are a load of locations to explore and be adventurous about.
Some recommendations if you like to drive: Highway 1, Highway 9 near Saratoga up to Skyline Blvd, Skyline Blvd near Alice's Restaurant to Half Moon Bay, Half Moon Bay on Highway 1, Santa Cruz to Half Moon Bay via Highway 1, Big Basin to Highway 9, McKrean road from South San Jose to Gilroy as you pass the reservoirs and Watsonville, Pacifica Highway in South San Francisco near the Pacific coast, Calaveras Road near the mountains by Sunol to Livermore, North Minds Road in Livermore to Mt. Hamilton near Lick's Observatory, etc.
Again, if you like exploring and driving, then it's amazing here. It feels like you're playing Legend of Zelda: Breath of the Wild in that every where you go on a road, you'll find something of interest not far from where you are. Other places I've lived in, a road can take forever to take you anywhere worthy or with anything of interest. But all those roads listed above? I randomly just turned on the navigation in my car and took random roads off the beaten path to find nice restaurants from down-to-earth ones like Alice's Restaurant to high end ones like Grandview Restaurant on Mt. Hamilton. You find little festivals year round. I randomly happened to stop by Livermore during its Shakespear Festival and stopped that evening just to watch a play, it was great. I stopped by Saratoga for Mountain Winery, a place I never knew existed for concerts and wine tasting along with a great view.
If you like water activities then there's a lot of places to find like at Berkeley's Sailing Club or even Rengstorff House off of Shorelines near Mountain View. These places may pale in comparison to Mission Bay Aquatic Center in San Diego, but they're still pretty nice. The list goes on since there are so many cities in the Bay Area.
Weather? We've got it pretty good here compared to most of the US.
Again, I tend to never defend the Bay Area, but I have to admit there are a lot of places that I never knew about until I started adventuring off the beaten path in a car and just explored. Try it if you haven't already.
Also, as much as I love Los Angeles, even on weekends, there is way worse traffic down there than there is in the Bay Area, and we already have it bad up here.