I think the TNG final episode was one of those interesting cases of a finale that wasn't so much closing a series as being that reminder of what the show was about and and having that optimistic edge to what the future might bring.
DS9 was very much a wrap up character story lines and call an end to it all.
Voyager was just.. Voyager.
Hm, regardless of the spotty and awkward nature of the 5th season of Babylon 5, the end episode pretty much was great emotions. Technically it was shot at the end of Season 4 when they didn't know they'd get season 5 to wrap things up.
But still, that jump to twenty years on, and ending with that music (and the cameo of JMS literally turning off the lights)...