It always sounded insulting to me because the word is a synonym for weird and “not right”. So I never associated myself with it.
I actually kind of like the association with weird, personally (not so much the “not right” piece, which I get as well). But I definitely know that the word has some less than flattering history. The last LGBTQ employee group I was involved in had a pretty in-depth discussion around whether or not to include “queer” in our official name/acronym and opted to go with including it. I will say that in my experience the word tends to be less preferred/used by gay men, and more celebrated/employed by lesbian & (more often) bi women, trans people, and non-binary individuals. It also tends to skew towards younger people who tend to not have negative associations around it in the same way (it certainly was not a slur I ever heard growing up).