I'm amused that folks love AGT (which I do think is a really good episode, just not as great as I think it's being made out to be) despite it containing elements which people consistently disdain with regards to later entries in the franchise:
1) It's almost entirely a Picard episode. Yes, the others get their moments, but it's definitely Picard-centric.
2) Reset button ending. Yes, Picard remembers what transpired, but nobody else does. There's pretty much no reason to believe the future timeline as shown will come to pass, or even something particularly similar.
3) Time travel (of sorts). 'Nuff said?
Again, I do consider it a pretty great episode, and it's a fine enough way to end the series, but I'm a DS9 man all the way, and ending their series with a multi-part arc and spending time recognizing everything they'd been through at the end clinches it for me despite the arguable weakness of the Prophets storyline.