The bottom line on the ratings is that TNG is the only Trek series to ever be a consistent success in its initial run with a general viewing audience. Something about it connected with the viewing public in a way that the other shows did not. I think today we often forget how successful TNG was and how much of a gulf there was overall between the shows. TNG was regularly pulling numbers that rivaled Monday Night Football.
I've said a few times before that I think '94 was "the peak" of
Star Trek. I saw a few days ago that "All Good Things..." is among television's top 20 highest rated series finales, which I would not have thought, frankly. When i think back on '94, it felt like
the moment for the franchise.
Personally, I think Paramount made a big mistake shifting TNG to the big screen.
On the one hand, the cast was signed for an eighth season.
On the other hand, Paramount wanting a network of their own (UPN) forced the issue of ending
TNG.
On the gripping hand,
TNG was kinda tired in the seventh season.
I agree with what
@Dukhat says later in the thread, that "AGT" would have been a fine final outing for that crew. I don't believe their movies ever justified their existence, and I never really needed to see them again.
But I do think that
TNG could actually have run longer if they had shaken up the cast. Worf still goes to Deep Space Nine. Data gets a promotion to XO on another ship. Riker gets his own command. People move on in their careers. New crew will come aboard when the
Enterprise stops at a starbase. I have long felt there should have been more cast turnover than there was, and the show could have run longer if there had been.
First Contact was its only real big success in that venue, and none of the other shows were able to duplicate its ratings on the small screen. The folks at Paramount seemed to think that because TNG was a hit, anything with "Star Trek" attached to it would automatically be a hit as well. If nothing else, TFF should have shown them that was not the case.
Paramount's idea was, "We can make cheap
Star Trek movies with this popular crew!" Only, the films weren't cheaper, and the films (imho) are just television reunion films with a budget.
With that said, I stand by my assertion that a Sulu show, produced by UPN, would have been no different than what we got with VOY and ENT.
This is key.
It would have been made by the same people as
Voyager in a hypothetical 1995. There is the slim possibility that Berman says no to making a
Star Trek series for UPN to launch with and the studio finds a different producer for the series -- I recall Berman saying at the time that if he said no that's what would have happened -- but otherwise, "Sulu '95" is going to get made out of the same office, with the same people, as
Voyager. Winrich Kolbe probably directs the pilot.