Unification did alright, it's just a shame the second part is awful. The set-up is great, but the pay-off is totally lacking. Birthright isn't exactly memorable, The Gambit is decent enough with some really nice scenes, and I enjoy Time's Arrow. It's not epic like The Best of Both Worlds, but it's a really fun TNG story. Obviously All Good Things is great, but it was always designed to be a TV movie rather than a two-parter.
The only one that matches BoBW was the superb Chain of Command.