I went through a similar thing in my first few trips to the Bay area, and ultimately decided to not move there for the same reasons.

I've found subsequent trips to be much easier. Unfortunately, the most vocal and easiest to meet within the community were the most abrasive / kool aid driven. Keep digging.