In my experience, yes. One of the biggest boons about moving from Metro Detroit to the Bay Area is that I don't get harassed in the street for being visibly gender non-conforming anymore. Detroit consistently votes Democrat but that's more to do with the unions than the social values.