I think that All Good Things was by far the best finale. TOS shouldn't even count. Endgame was good and had the best battles of a finale. I REALLY wanted to love DS9s finale but the whole Pah Wraith subpot was TERRIBLE!!! I just rewatched the entire series and finished it last week. It wraps up most of the plot lines but was derailed with the whole Dukat/Winn subplot.
For what it's worth, I watched TNG during the original run and was hoping they would end with them playing poker. Appropriate ending.