TNG had a few memorable and entertaining episodes in S1 (like "The Battle" and "Conspiracy), but the rest of it was quite ghastly, cheesy, and poorly dated. S2 was a pretty big step up in story invention (the introduction of the Borg and hologram Moriarty), but still had its quality issues and cheese (the Pakleds?! Come on!).
Halfway through Season Three leading into Season Four was when TNG got genuinely excellent with "Yesterday's Enterprise", "Tin Man", "The Best of Both Worlds", and "Family". The quality generally kept up until the conclusion of Season Six.
The Next Generation definitely hit the creative buffers in Season Seven (with many weird, boring episodes like "Sub Rosa") but what was great, was still as great as anything from the S3-6 zenith ("All Good Things", "Parallels", "Below Deck", "The Pegasus", and "Preemptive Strike"). By S7, it was clear the core writers were getting creatively burned out, after many years on TNG, however the anti-S7 is a little excessive.