I hated him in the first couple of episodes too; but when TNG started, I felt like everything was overly dramatic. Picard bellowing out heavy-handed soliloquies, Worf growling and gnashing his teeth, Riker swaggering around pretending to be Kirk from the old days… things settle down pretty quickly though, and the characters become less two-dimensional.

As for Q specifically, he’s not around a whole lot, but he makes an appearance or two per season maybe. He ends up more curious about humanity than being adversarial against humanity, but he still sometimes just throws a monkey-wrench into everything for his own amusement or to test a theory, once in a while.

Stick with it, it’s a really good show.