TNG was a great show, but then it was followed up by three subpar and one OK movie.
TOS had what, a dozen good episodes, yet it got five good movies and one awful movie? Not bad.
I'm satisfied DS9 ended on a high note. RDM and Behr would have already moved on by then. Would you trust Berman and Braga to do DS9 justice?