As someone from San Francisco, I'd suggest at least looking into it as an option. (I'm a straight white guy though so maybe not the best source here...). In particular https://en.m.wikipedia.org/wiki/Castro_District,_San_Francisco
For some color on the type of neighborhood it is, here's a recent incident. Unfortunately it involved some violence, but the good guys won (I don't think it should be triggering...): https://sfstandard.com/2024/07/11/nudists-save-tourist-attack-castro/
Of course, San Francisco being in the US, I wouldn't blame you for trying to find somewhere else. But California (and SF in particular) is very different than Trump country.