Most definitely. I think Voyager was the happiest because they achieved their fondest wish at the end, though I found the ending truncated, as I've like to have seen their arrival on Earth and reunion with their families/friends.
I always saw the DS9 ending as bittersweet insofar as the crew survive and have a brighter future ahead of them albeit the great cost. Kind of like the S1 finale of Daredevil: Hell's Kitchen is safe and there is hope for the mean streets - but it took a lot of bloodshed to get to that point.
it's not really a finale, even though Coto intended it to be the basis for a finale. Berman and Braga writing their "love letter" forced Coto to truncate the finale he wanted to produce, making it more or less an ordinary episode--a great, spectacular episode, but not one that brings finality to the stories, the settings, the characters or their relationships.
I believe it's called "These are the interferences of the former craptastic producers, whose 45 minute mission is to shit all over what happened in the past season and hand the show over to some has-beens." I might be one or two words off.
I think it was certainly the most "bittersweet." This was a crew that was never going to get it's own movie, and was very much about political and religious upheaval even at the outset. So with all of these changes in the final episode, like the ending of a war with the Dominion, peace with Cardassia, Bajor joining the Federation, and Sisko fulfilling his prophesized role as Emissary-- and with no need to save them for a followup movie-- the writers crafted a more realistic and more natural ending, as would happen in a political/military organization like Starfleet, after the conclusion of a war. I actually think they weren't bold enough: it would have been interesting to see someone actually die in the last episode, someone like O'Brien, without an "out" like they gave to sisko. But I guess they learned their lesson after killing off Kirk in Generations.
DS9 is the saddest 'In a good way' ending, but TOS and Enterprise's endings are sad in different ways.
DS9 wins the saddest ending award. Deep Space Nine was our home and the crew, our family. I think we all wanted to stay and keep things going as they had been. Good thing for rewatches. TNG - Best ending was the ship (ENT-D) flying off into the stars for continuing adventures. VOY - Ended with no epilogue, and that was just unacceptable. Instead of half the 2-parter being focused on a future that is going to be erased. Seeing the marooned and stranded crew reintergrate with society on Earth and catching up on all the things they missed, would've been excellent. ENT- Ended with Terra Prime. This show may have stumbled out of the gate, and took a hit in the shins, but it brought it home for it's final hour. TATV can burn.
I can understand his reasoning. He was the first African-American captain in Star Trek with his own show and he knew what some people might say if Sisko died so soon after Kassidy got pregnant. Again, I can understand his reasoning.
Even though I despise Enterprise, actually loved that ending yeah. I'm not a fan of the DS9 ending, I really hated the whole PaWraith stuff and the way Sisko went, just weird way to end it.