Bad news first: I don't particularily like the Future Enterprise, for various reasons. First of all it is a too militaristic design with the new "Death-Star-Phaser" and all these additions to her hull made her look "disrupted". Her elegant, majestic design is buried under unnecessary add-ons.
There is hardly any ship in any show which looks as majestic as a Galaxy-Class. Making her look military is simply odd and in vain, because there are ( at least by now ) far better military designs, like Akira, Defiant, Sovereign-Class.
Additionally the three-nacelle configuration looks not very good in my point of view. The extra pylon looks far too large and the whole position makes it appear as if it does not belong where it was put.
However, no to the good news, I escpecially like the last episode of TNG. Voyager's last episode was rather strange, too much concentration on the always troubled Borg-arc. And I always missed to see what actually happened to the crew afterwards, would have like to see that after following the crew on that journey.
DS9 at least layed out what was to happen to the characters, but since the battle for Cardassia was rather short and most parts of the episode concentrated on the paranormal "Sisko is a God"-story line, which I never particularily liked.
TOS had a standard episode as its last and ENT was, well stupid ( see the appropriate thread for my more elaborate opinion ).
TNG had a very interesting premise and I like the idea of connecting the beginning and end of the series the way they did. The only thing I did not like was that at the end there was no change in the crew or whatsoever, which called for a "break". It did not seem that this part of the story was at an end - to stop accompanying the TNG crew at this point seemed to be arbitrary...
Besides I especially like the end of the episode, where Picard joins the staff to play poker and realizes he should have done that a long time ago, since this is his family. The beauty shot of Enterprise as a last view was nice as well.
I really love the series and AGT as well.