One thing that’s always annoyed me is immediate reaction to Qs appearances, the inevitable voicing of “Q” in that tone. I get it, it just annoys me.
Not all Q's are annoying (ST Voyager). But can be a source of humor and unbelievably a sense of morality.
Its only Picard he pissed off because Picard didn't like him and he fell for it. Mind you in Q's first appearances in ST he was written as a total prick but then evolved into a new different character. Then Q appeared in DS9 and look what happened there.