Something that's always disappointed me is how despite the dire consequences that are about to unfold, the show will just go to credits usually instead. I get that with TNG it wasn't supposed to episodic and there was a certain humor in "Well we just made things worse, let's be out" but DS9 can't move to another location so they're usually forced to deal with things.
I think endings have always been a weak point for Star Trek TV series in general. Anti-climactic is probably the best term to use. Especially given that a lot of multi-episode story arcs used to end near the beginning of a season.