Season seven is the pits. Far, far too many of the episodes involved random long lost family members. It happened with all the cast (although in Riker’s case it wasn’t a family member but a long lost commanding officer, in one of the few good episodes).
Early season 4 was apparently popular with dragging out the family members for plotting, so why not do it more and more and more and more? I mean, that kept working for "The Golden Girls", right? They even had multiple actors playing the same ex/kid/etc and that never got tiring... well, it had as well, but when it doubt trot the trope out... season 7 TNG doesn't fare any better.
Too often, definitely, TNG7 is going down soap opera land again. At times it feels like it's trying to go back to the action/adventure format of seasons 1 - 3, but just can't do it.
The one with Picard's 'son' being a rehash of "The Battle", complete with Daimon Bok (again) and his being out for revenge (again). "The Battle" did it pretty well already.
Data's "mother" gets explored too, how exciting... at least it's only dull, there's no contrived Exocomp stuff...
Even the writers have admitted they were running on fumes. And yes, although DS9’s concurrent second season was far from its best, it was far, far superior to TNG’s final season.
Even episodes like "Gambit", which feels middling despite having potential in there (as well as universe building), feels - as well as being a potential DS9 story - feeling tired and cookie cutter too often. Even improving the music would have elevated it. But that said, stale or not, TNG7 definitely felt like it was trying to rise above the soap of 5 and 6...
DS9 season 2 rocks.
Mind you, I’m one of those strange people who prefers the first two seasons. I’m fully aware of their objective failings, but I find them so much more enjoyable to watch.
You're not strange, or alone. Lots of fans do. I recall in 1994, watching with a friend and some of his family who were visiting, one said how he preferred the older episodes, citing their being corny but being more adventure and action driven. Which is even weirder, since "Gambit" definitely is an action adventure trope, but feels knackered.
They have a sense of freshness, boldness and excitement which was sorely lacking in the back half of TNG. The music was great, too!
The first half of TNG's run often felt cinematic. The composers knew what to get out of the scenes and it shows (or is heard, rather

). Ron Jones did get into excesses ("Booby Trap"'s climactic escape scene's original score is jarringly bad and was replaced, despite the rest of the story's music being otherwise solid) so it's understandable why the tone would be clamped down, but the music went way too far in the other direction and as a result a lot of stories suffered to the point that no incidental music would have been better ("Power Play"), The show had the same composers, it was the new tone being set that ruined it.
While I think Michael Piller was a pivotal addition and a great contributor to the franchise, I have mixed feelings about his insistence that character must come before plot. The problem with putting character front and centre on TNG was the fact that these characters just weren’t particularly interesting or dynamic. For example, I used to dread episodes focused on Geordi, Troi or Beverly, and even the Worf episodes could bore me thanks to the caricature treatment of the Klingons.
Character development and interaction are surely essential to any show, otherwise seasons 1 and 2 would have tanked? They are clumsy but still have a greater balance that the latter half often lacked. Soap opera is just drippy excess, for which "V The Final Battle" was doing backstroke after backstroke in as I wanted to find a non-TNG example as that'd be too easy, but I digress...
Ironically, new character Ro had the most underlying character of the lot in TNG's second half, but - what with season 5 and all - the secondary and guest casts would always be the butt of situations and our clique bridge crew were always 100%-pure-dee-right-rubber-stamp. 'Ethics", save for the Worf/Riker scenes, was
bad, but before I digress...
The Klingons got watered down too much, but I'm impressed how well DS9 revived them wonderfully and did something to liven the show (as well as invigorating plot ideas by ending the peace treaty successfully and in a way
not involving the Organians). TNG's format just couldn't go the level needed, since after "A Matter of Honor" they start to get demystified like pie crust under a rolling pin then left out to dry -- becomes flat and stale, especially after "Redemption".
Some Geordi episodes could be good and focus on real character development without being diluted out of the sci-fi genre into generic soap opera ("Interface" was his best story since "The Enemy" and it holds up well, even with the music. If it weren't for being so flat in tone, combined with Geordi peeking at personal logs that are no longer classified now doesn't help the situation, it'd comes close to being good, but there I go digressing again... )
Riker was just a(n elevated) Kirk archetype and every time he went to appease his hormones, Starfleet almost gets compromised. Riker still had great stories and scenes, but I'm impressed on how "The Game" tries to not mention beyond the opening few minutes that Riker's frequent flyer miles in a motel on the Risa sex planet doesn't bring up the larger issue. Yep, I'll defend the DS9 Risa episode because that one at least tries to address the issue (even if inconsistently and lamely, giving more time to the soap opera breakup subplot shtick). Then again, espionage agents do it all the time (see the James Bond movies as an example of this aspect of "cowboy diplomacy, yeehawww!")
I wish they’d committed to more high-concept sci-fi and less generic soap opera from seasons four onward (another season obsessed with crew members’ family).
^^this, this, this, this, this, this, this, this, this, this, this, this, this, this, this, this, this, this, this, this, this, this, this, this, this, this, this, this, this, this, this, this, this, this, this, this, this, this, this, this, this, this, this, this, this, this, this, this, this, this, this, this, this, this, this, this, this, this, this, this, this, this, this, this, this, this, this, this, this, this, this, this, this, this /melodrama
Early season 4 was novel, what with the Borg aftermath and all, but that was the reason it was watchable at all as people were still high off the Borg resolution - it's not as rewatchable, but by the "Suddenly Salad" one it already felt petered out. "Remember Me" took a new direction on the trope, using - yep - good sci-fi again and is so much more memorable and a sign that TNG was back on track.
While I wish there were more and more memorable ones, there were some examples of sci-fi goodness in season 4-onward, like "Ship in a Bottle" (despite using a story from early season 2 but, shhh, we won't mention Pulaski), "Timescape", "The Next Phase" (roll with the physics stuff, the rest makes up for it and more), "Power Play" (sans music), "The Pegasus", et al - but they are too few solid sci-fi entries in among the soap opera. Even "Genesis", for all its faults, is trying to return to the basics and it's a refreshing change. "Realm of Fear" became too mired in soap opera despite trying to explore a new facet involving the transporters... season 6 did do the same plot reuse overuse trend like what season 4 had, just swap out "the family" for "the transporters". A shame they didn't sprinkle the trope across the season instead of airing the lot of them back-to-back.