I did this for fun recently... and possibly was a bit too generous. But, hey! 
For those unaware of tier rankings, “S-tier” is the top, followed by A, B, C, D, and finally F.
S-Tier:
Lost Mine of Phandelver (original starter set)
Curse of Strahd
A-Tier:
Hoard of the Dragon Queen
Rise of Tiamat
Storm King’s Thunder
Tomb of Annihilation
The Wild Beyond the Witchlight (but haven’t run it)
B-Tier:
Princes of the Apocalypse
Out of the Abyss
Dragon Heist
Dragon of Icespire Peak (Essentials Kit)
Shadow of the Dragon Queen (I rate it a F as a representation of Dragonlance lore)
C-Tier
Dungeon of the Mad Mage (but I haven’t run it)
Rime of the Frostmaiden (but I haven’t run it)
Dragons of Stormwreck Isle (new Starter set; haven’t run it)
D-Tier
Phandelver and Below: The Shattered Obelisk
F-Tier
Baldur’s Gate: Descent into Avernus
The full article explaining a few more of my choices is on my blog, if you're interested.
However, considering your own experiences with the big campaign adventures from Wizards, how would you rank them?
Cheers,
Merric

For those unaware of tier rankings, “S-tier” is the top, followed by A, B, C, D, and finally F.
S-Tier:
Lost Mine of Phandelver (original starter set)
Curse of Strahd
A-Tier:
Hoard of the Dragon Queen
Rise of Tiamat
Storm King’s Thunder
Tomb of Annihilation
The Wild Beyond the Witchlight (but haven’t run it)
B-Tier:
Princes of the Apocalypse
Out of the Abyss
Dragon Heist
Dragon of Icespire Peak (Essentials Kit)
Shadow of the Dragon Queen (I rate it a F as a representation of Dragonlance lore)
C-Tier
Dungeon of the Mad Mage (but I haven’t run it)
Rime of the Frostmaiden (but I haven’t run it)
Dragons of Stormwreck Isle (new Starter set; haven’t run it)
D-Tier
Phandelver and Below: The Shattered Obelisk
F-Tier
Baldur’s Gate: Descent into Avernus
The full article explaining a few more of my choices is on my blog, if you're interested.

Tier rankings of the D&D Campaign Adventures
Does not appear in this list. but will soon! For those interested, here are my tier rankings of the official D&D 5E campaign adventures. Some may be a little generous, but sort of match how hap…
merricb.com
However, considering your own experiences with the big campaign adventures from Wizards, how would you rank them?
Cheers,
Merric