yeah, Lost Mines of Phandelver is a classic to me, but the follow-on Shattered Obelisk is a swing-and-a-miss - I may actually sell my copy.
I'd like to root for Tomb having read through it now (the starting city itself is fascinating), but the way our DM ran it, I would have put it in worst adventure path territory - but I think I have to say that's all on the DM. I'd like one day to DM it and see if it really does play as good as it reads.
Any others I would nominate would simply be reprints from previous editions - Curse of Strahd, Ghosts of Saltmarsh, Tales from the Yawning Portal's content and Quests from the Infinite Staircase content (though I admit I haven't gotten to actually run/play the latter) mainly.