I've only seen a few episodes of TNG, but mine is Q is lame and unenjoyable. Maybe he gets better as the show goes on, but having the first episode involve him was a bad decision.
The pilot episode script was for a single episode about Farpoint, the suits decided it should be a 2 parter pretty late in the game. The writers tacked on the Q plot in a bit of a rush. I'm not a fan of the next Qpisode either, that one is just classic season 1 TNG badness, riffing too hard on classic trek before they found their own voice. His appearances get better and better.