Just finished rewatching DS9. I remain a little frustrated at the ambiguity of Odo's final scene, and to a lesser extent Sisko's. I think there's less emotional satisfaction not knowing if they'd ever return than knowing one way or the other.
Also odd: Worf's finale montage not having a single scene involving Jadzia.
All in all I think the show has generally grown on me since the last time I watched it. A lot of stuff works very well. Vic Fontaine has grown on me. Ezri is actually a pretty impressive example of how to introduce a character late in the game and still give her depth. I think the finale Dukat/Kai Winn plot actually works fairly well.
A few things about the show simply do not work. Bashir's genetic enhancement is embarrassing--an easy an obvious misfire from the first time it is brought up, and then they continue to include it in MANY subsequent episodes for no reason. The Maquis plot was pretty half-baked. The Jem Hadar feel neutered in the last season or two of the show, and the Breen don't work at all. The Changelings never have a good moment after Odo is turned into a human. Every episode after that they are pretty unthreatening.
Finally, the show really feels starved for budget. No set comes even close to the Promenade, and as a result, none of the moments meant to portray scope or scale or the centres of the galactic powers work. In contrast to this, TNGs Klingon High Council episodes feel suitably high budget. The Changeling/Cardassians last stand is pretty laughable, with Kira, Garak, and one other rando able to storm the Cardassian command centre, which is apparently a hallway and an office. I don't like the abuse of chroma key VFX virtual sets, but at least they allow us to pretend.
The same is true for the cast size. The effect of the Prophet's appearing as familiar faces feels cheap. We only see maybe 3-4 Vorta in the whole series. The female Changeling is the only face of the Founders. On the federation side, only Admiral Ross seems involved in the war at all. In the final battle, we see only the Sao Paolo/Defiant 2, Ross, Martok (literally no Romulan appears at all in the back half of the seventh season). Just makes the whole thing flimsier.
In terms of narrative, I think DS9 has a better ending than just about any sci-fi. I just really wish it was made with HBO's budget and ability to target a slightly more savvy audience and the advantage of another decade of technology.
Next up, my first watch of Babylon 5, which is WAY more low budget.