I ran Dragon Heist twice, the second time around in reverse. They were Xanathar's goons in charge of retrieving the dragons, which Jarlaxle stole. They had to reverse-engineer the whole heist to understand what happened, under pressure from their crazy boss. It was super fun — and only made possible with the inclusion of all the vilains' lairs in the book, which otherwise aren't used in the campaign if you only play it straight like it is. (But with a full gazetteer and all this fun material, it is simply begging to be stripped for parts and reorganized as you wish.)
I also ran or played Tyranny of Dragons, Curse of Stradh, Tomb of Annihilation (twice), Out of the Abyss (twice), Lost Mines and the Essential Kit, Rime of the Forst Maiden and Descent into Avernus (the first chapter twice). Oh and Shadow of the Dragon Queen and a bunch of small ones from the Anthologies.
Shadow of the Dragon Queen is the real outlier, here, as I found it to be barely playable, like the AP of old. Just a bunch of exposition scenes without any meaningful connective tissue, without any relevant choices for the characters outside of the immediate actions the set-pieces allow (which aren't especially great; at least in Tyranny of Dragons there's no forced exposition, and the set-pieces can be ran like a charm with the book on the knees and a quick reading just before the game).
All the other are quite good products and I'm happy to have them. Neither of them perfect, but all interesting in their own way. Some I played straight as is, with various degree of success, some required some work, some required a lot of work to get to something I was happy with, but I'm sure some other tables could play them straight without any trouble (like Dragon Heist). I'd say Lost Mines is probably the one with the fewest faults, but that's mainly because it's the safest, IMO. There is hardly any risks taken in there. At the opposite end of the spectrum, DiA might be the most flawed, but also one of the funniest, one of the most epic and inspiring. I had a great time with it (and I'm currently running it again and it's even better with this hindsight. We started from Elturel, this time). It's disjointed and messy, a sign of a chaotic process during production for sure, but still. Good book.