Light derogatory, most of the time it’s used half-ironically by other people in the same fandom. (Which is the OP joke)