DS9 gets my vote. The Final Chapter has slipped a tiny bit over the years but first-run it was a thrilling ride. I loved its epic scope, the number of characters involved, everyone contributing their part to the greater mision, the resolution for the cast.
There were weaknesses such as Worf/Ezri/Bashir, Extreme Measures, the link between Odo and Founder ending the war but overall it was fun and that is all I can ask. Then there were episodes like Treachery, Faith and the Great River; Badda Bing Badda Bang, Take Me Out to the Holosuite etc.
Granted there were a few disappointments like Chrysalis, Afterimage, Covenant, Prodigal Daughter etc but even a few of those in repeat aren't nearly as bad as I remember.
This season very well may be my favorite of DS9 because it used what it had established so well, really felt like a bittersweet final season and by the time it ended felt like it had generated enough momentum to carry over into another season something TNG or VOY didn't do in its seventh and final year.
TNG would come next. TNG is my favorite series but even I would have to admit it was a shadow of its former self. The show took a hit from so much going on and attention being divided among DS9 season 2, getting VOY ready and work on Generations.
I also suspect writer burn out played a role as well. And the show's two best writers, Brannon Braga and Ron Moore, being less involved didn't help much either.
The show just felt like it was running on fumes. Several episodes like Masks, Emergence, Eye of the Beholder, Force of Nature etc had good ideas that just weren't mined as well as they could. Others just didn't work. I still enjoyed some episodes like Parallels, Genesis, All Good Things. I think this was an example of a tv show going on one season too long.
VOY I would rank last. It wasn't awful it just was mediocre. The much hyped showrunner change with Ken Biller didn't bring about the quality improvement many believed it would. It still had its weak hours---Friendship One, Natural Law, Nightingale, Drive, Q2, Prophecy etc and its bizarre contrived elements like Seven/Chakotay.
Endgame as a two hour episode is entertaining but as a series finale is lacking a great deal in terms of resolution and poignancy although Kate Mulgrew did a great job portraying two different Janeways, the visuals were outstanding and Alice Krige did a great job even though by this point the BOrg were nothing like they used to be.
You could tell attention was clearly being focused on ENT pre-production.
Ethros said:
I remember watching 7.02 Imperfection and nearly vomiting in disgust when Tom says "come on, lets go in the Delta Flyer" or something, despite it the fact it was destroyed in the Season 6 finale. Oh yes... I guess they just built a brand new one already... and didn't even bother explaining it... and it looks exactly the same...
Simply poor
Well actually Drive was shot first and was meant to air after Unimatrix Zero II but instead Imperfection was shown.