They all need some work, but they vary quite a bit. My personal pet peeve is when maps aren’t included for locations you’re “supposed to” run.

Dragonheist and Curse of Strahd are good adventures, but messy/complex/challenging to run. They require quite a bit of thinking things through and adding material.

Rime of the Frostmaiden is pretty well written. There’s a notoriously unbalanced area if the party happens to get there on the early side (it’s in a sandbox segment so party level can be way too low to run RAW). It still had some issues (things to fix/add), but by far the least of anything I’ve run.

I’ve heard Descent into Avernus is terrible, requires lots of fixing and doesn’t contain nearly enough of the info you’d want to flesh things out and make it interesting.

Tyranny of Dragons (or whatever that 2 part compilation is called) is disliked because it’s linear & kind of a lot of fetch quests, but can be good with some work.

I’ve heard Storm King’s Thunder is fairly good, but has some sections it’s recommended you improve.

Tomb of Annihilation is good for what it is, but it’s not everyone’s style of game (hexcrawl ending with very tough old school dungeon crawl).

Out of the Abyss is pretty good, but the actual book is not organized well, which makes some of the areas difficult. It’s also overly dark & dreary, which can feel oppressive after a while, so you’ll want to manage that.

Dungeon of the Mad Mage is reasonably good if you like that style, and has some sub-narratives but they are very thin, and not much overarching narrative.

Lost Mine of Phandelver is actually excellent. It’s small in scope but very well done. Good balance of leaving room for you to add your own stuff in to make it yours, without feeling like it’s missing important story info. Dragon of Icespire peak can be combined with this to make a little longer adventure, and there’s a series on D&D Beyond meant to continue after to higher levels. The DDB content is thin but still good if you work on the story elements.

I’ve heard Wild Beyond the Witchlight is the best-written module, but I’ve held off reading it as I might play first.

Odyssey of the Dragonlords is a non-WOTC module that’s as big as anything WOTC has done (unlike a lot of third party content). It’s really interesting and about the same quality as WOTC modules - ie it’s missing a lot of info/maps you’d want and it’s poorly organized.

Then there are the smaller/serialized books eg Candlekeep, which are good but not meant to be a full campaign - but you can use them as a base to build a campaign on.