There are tons of amazing communities in the Bay Area. In SF proper Sha'ar Zahav comes to mind (in the Mission). If you travel on Shabbos, Kehilah and Chochmat HaLev in the East Bay are both lovely and very progressive if that's what you're looking for

I can recommend The Kitchen - in SF - which is progressive but also hard to describe (unaffiliated, Sephardic music, fabulous Rabbi).