this episode (s01e07) is about this cunt.
I DO like Q as a character and episodes with him (or at least what I've absorbed from culture + lower decks).
however, if I were in starfleet, my reaction to seeing Q would be much like the lower decks characters reacted: "oh my god this motherfucker. get the fuck out of here."