I consider All of Our Yesterday's to be a finale worthy of TOS the series.
All Good Things a great end to TNG run.
What You Leave Behind had a powerful and tragic ending to the Dominion War. The Emissary, Prophets and Pah Wraiths parts i could do without.
Endgame felt like AGT and a quick fix to getting VOY home. I don't mind the Borg getting their teeth kicked in again. However I would've liked to have seen the crew actually make it back to Earth and see the Federation that haven't been apart of for 7 years. That's really all i wanted.
ENT ended with Demons and Terra Prime. TATV? I don't know what you mean.