I've run a bunch of the hardcover adventures, when I was still running my FLGS' organized play campaign. There were a bunch that I found "meh" at the table. Some were fairly bad for various reasons (Princes of the Apocalypse I really wanted to like, but had logic issues throughout). The ones that were big hits at my table were Murder in Baldur's Gate (though the players didn't pay a lot of attention and several still didn't know what was going on at the end), Out of the Abyss (I treated it like the megadungeon dungeon-crawl that it was), Tomb of Annihilation (dinosaurs and tombs, can't go wrong), and Ghosts of Saltmarsh (though I heavily modified it from the book). Curse of Strahd would have worked better, I think, if it wasn't run in a hobby shop with heavy through-traffic for 2 hours every Wednesday; they really liked Death House.