I suspect that 99% of the reviews on Amazon would be based on reading the adventures, not playing them. I have no idea what that percentage actually is!
Having run most of the hardcover adventures released, my own idiosyncratic ratings put the top three as Rise of Tiamat, Curse of Strahd and Storm King's Thunder, with all other adventures being competent with the exception of Dragon Heist and Descent into Avernus. Dragon Heist is salvageable - and, indeed, I have run it three times - but Descent into Avernus is the only adventure Wizards has released that I think is a massive disaster.
(Why do I rate Rise of Tiamat and Hoard of the Dragon Queen so highly? Partly due to ambition and scope - there isn't another series that treats the PCs as important in the world with the rulers of nations listening to them. Neither are 'complete' adventures as both require a lot of input from the DM, and they have other flaws beside - but I love them dearly).
Cheers!