You'd be surprised, to find that gays are a minority in San Francisco and declining in numbers. They have been leaving over the last decade or two, replaced by straights. Their political influence is waning as well. They were largely confined to the Castro district at Castro and Market, extending into Noe Valley and parts of the Mission district. Most of the city are regular families with children. There's been a resurgence of straight tech workers moving into the city, displacing others. Baby strollers and children playing are commonplace sights everywhere. As I said, be careful about painting with too broad a brush. I've seen far crazier batshit stuff in other cities (like Austin, Seattle, Washington, New York, etc.) than in SF.
You are correct about SF. Its a city of extremes. One of the most conservative people i know lives there.
I lived there a few years in the late 80’s.
Wacko city government for sure; but there are wackos everywhere now.