Weren't seasons 5 through 7 closer in spirit to soap opera-style? Definitely more melodrama for its own sake and less sci-fi.
TNG could have done follow-ups with any plot points, like the Ornarans, or Brekkians or others, without becoming soapy. Finding a reason to make it compelling to the audience might be. after all, the Pakleds made a return in season 1 of Lower Decks - something nobody expected or otherwise might have wanted - except the effort put into making them more compelling was pretty nifty and, indeed, wowed viewers. The Brekkians would surely have a massive tiffy against Picard's band of pesky meddlers so how to lure them back convincingly would still be as important than the genre format (high concept sci-fi, soap opera-level drama, war stories, and/or anything in between).
Of course, too many revisits, sequels, or coincidental match-ups like how the doomsday machine planet killer from TOS was apparently designed to destroy borg cubes, et al, also risk the problem of "small universe syndrome" and the universe is rather a big place. Most shows end up using this trope when they start to hold off on releasing big new ideas (or if they're out of it so they look back and build upon what was told). Doesn't mean it's not done well, it's only a risk that all of a sudden some various random incidents have a big common connection... or, worse, characters: Red Dwarf turned some of its hapless characters into big epic
hero-types popsicle sticks by fleshing out their backstories and the fanservice got old. Sliders had hapless kid inventor genius Quinn Mallory now being a superstud from another dimension who can beat off the Big Threat of the Kromaggs in all universes, with his little brother Charlie of course. Doctor Who used to be a wanderer and randomly helping people but was turned into Spacejeebus, complete with loud soppy muzak so we all can cry enough to fill up enough pitchers to fill with lemonade flavor drink mix to satiate three world series' worth of ball games, etc, etc, etc...
Or, worse, whip out that old standby of "it was just a dream". Most notably for the sitcom "Roseanne" where the series finale retcons away six seasons' worth of draaaaaama by finding an episode involving a writing room and all this time it turns out the lead character was writing a book about what-ifs. Or that season from "Dallas". It's one heck of a fake-out, but clearly was used in soaps and other shows that adopted soapy styles mixed in. Even as someone cynical like myself would not want to see seasons 5-7 wiped out, with Picard waking up after being saved by the crew having dreamt it all up. Or, worse, he wakes up as a drone and seasons 4-everything was a dream in the magical land of Unimatrix Zero where the address is anything
but 255.255.255.255., of course... if it's all in his mind then it's 127.0.0.1...
But I digress.
Data could have been turned off at any time with any script*. He amazingly
wasn't when Tasha was groping him in "The Naked Now" as the location of his off switch is not an uncommon place where lovers touch each other. before groping at the good parts...
...But he also sorta was in "Nemesis", with such a rubbish draw-by-numbers mimeograph copy of Star Trek II and III's handling of Spock's death that nobody probably gave a darn, dang, hoot, damn and/or one of them unbleeped bleepy words found on all the cable/streaming channels.
* The number of times Picard threatens dismantling him in a show that otherwise treats him as a sentient organic lifeform yet Picard never threatens anyone else** with what's tantamount to dissection and/or murder... oops...
** apart from
arguably the quaint role reversal in the film "First Contact", since - what with TV Picard's crew saving his hind and removing the implants in the TV show and all, and with comparative ease - Movie Picard now guffs and gloats six years later how it's oh-so-much better that his crew are killed instead of being rescued and de-borgified as he whips out the tommygun to mow down several (former crew, woops) instead of finding any number of ways of subduing them to later save them since it's not like the crew were in what seemed to be in an unstoppable posi-- oh, wait... But let's see, they're in a holodeck, magical safeties are off per plot regulation 42007, order Mr. Computer to fart out some knock-out gas, the Borg all take a nice big whiff, they all keel over quickly because they've not had to adapt to anything even remotely like it before, and voila - out cold like cats after catnip to be held in force fields they can't adapt to. Of course, then there'd be no later scene involving epic temporal malarkey about "watch your future's end" with more Jean McClane one-liners that are a bit out of place, never mind how they got back home without the deflector dish to reproduce the Borg magical tunnel (aka 50000th way to initiate time travel on cue)... but I digress again.
