I use it more derogatorily then gay nowadays.
Usually my go to is if someone puts "a" in front of their descriptor it comes off as more an insult.
Someone might identify as gay or queer but having someone asking if they're "a gay" or "a queer" comes off as more accusatory as if that's a bad thing to be.