I don’t think I every finished a TNG episode! I found the characters too pretentious and annoying. Data I constantly wanted to do ‘ctrl alt delete’ to!
I always wanted Wesley to meet a gruesome end.
There were episodes of TNG that I really enjoyed. Then there were episodes that were just a slog to get through. The episodes with Q were usually fun. I agree, the Federation of TNG was just to damned “tidy”. Deep Space 9 had a grittier feel to it, and the characters developed some real depth during the series.
Same with Voyager. I kept watching hoping that Chikotay would don a red uni.