Late to the party, but ....
1) Curse of Strahd - this has been an excellent adventure since 1E, and 5E just expanded on it spectacularly.
2) Lost Mines of Phandelver - great starting adventure, well put together and hits all the good points of D&D play
3) Ghosts of Saltmarsh - the 1E versions were classic, this is a good update and a lot of interesting extras and expansions thrown into it
4) Tales from the Yawning Portal - classic update of some really good old adventures. Not meant for use as a campaign, but great to pull one or two them into an existing campaign or as a side quest
Mid Tier
Rime of the Frost Maiden - had me riveted reading, but didn't come across as well in play. The constant storm is interesting for the first couple of sessions, then ...annoying.
Failure Tier
Horde of the Dragon Queen
Lights of Xarysis - A railroad of a (disaster) adventure that tries to sell itself as 80's Flash Gordon and just fails at every point - including a (literal) murdering of Dark Sun/Athas
I don't have the other adventures, but glancing through them they did not grab me in a way that I felt I needed to acquire them (I'd be curious to see where folks rank Witchlight). I will say the Mad Max rip-off in Descent really turned me off to grabbing that one (as did other reasons), and that Dragon Heist didn't involve a dragon's hoard lost my interest as well (seems it's more of an "Ocean's 11" sort of adventure). I've got the original Undermountain series, and with Mad Mage only covering a small portion of the original, I skipped it.
Unfortunately, I am stuck in a campaign that is butchering Tomb of Annihilation, and because of that I really can't recommend it.