If you're working in SOMA I'd recommend Lafayette/Walnut Creek/Pleasant Hill and take BART, or Alameda and take the ferry. Also could live mid-Peninsula and take Caltrain, but housing down there is $$$$$ now. If you want good weather on the Peninsula you need to be south of 92.
Ignore the people that told you to immediately write off Walnut Creek. It's real nice out here, and BART is only 35 mins to Montgomery station. Coming from the Midwest you'll probably be more comfortable east of the Berkeley hills, as there are sort of real seasons here. The hills block all the shitty SF weather. We have a real summer (not crazy hot, gets up to 90-95 dry heat and occasionally 100), true fall color, and it even gets down to freezing overnight in the winter. If you like going to the mountains it is a much better drive if you live in the East Bay than trying to get out of the city or the Peninsula across the bridges and inner East Bay traffic hell.
Also ignore the people saying Alameda is a dump as they apparently haven't been there in eons. There are many very nice parts of the island.
You're going to hate yourself if you try to drive to SOMA and pay to park.