In my opinion the only thing that bothers me is WOTC seems to constantly release large campaign books. I miss the days where there was large numbers of choices for smaller modules and the DM created a custom campaign by selecting unconnected modules of appropriate level.
Too much now seems to be create a 1st level character and level them to 10 plus by running the same hardcover for the next 3 to 6 months depending on how often you play, then rinse and repeat.
See previous comment about AP fatigue.
They tend to be bland and reptitive after a while and not every AP will appeal to everyone.
Making back to back books set in Waterdeep also isn't that useful if you don't want to run in Waterdeep. Then if you don't like the AP before or after Waterdeep APs it's 18 months maybe two years where the adventures didn't do much for you.
Writing adventures is also an art form not a science. You can make consistently ok to good adventures but few will stand out, Pathfinder has this problem, WotC probably does as well.
Personally IMHO PotA is probably the best one and maybe ToA/CoS.
The rest are either bad (HotDQ, SKT), hard to run (OotA), or have a specific focus which may or may not appeal.
Everything's subjective but DotMM, DH, HotDQ, SKT are probably near the bottom of the pile and PotA, CoS and ToA near the top.
IDK if any are truly great though and will stand out in say 10 years time. Maybe it's because they're derivitive of other adventures IDK but the don't have a Lich Queens Beloved, Rise of the Runelords, Kingmaker, Savage Tide, Desert of Desolation stand out moment. LMoP the will, maybe CoS the rest IDK.
Throw in that I suspect most don't get completed and you will have that "decent adventure we played it once upon a time" vs we cleared out the caves of chaos sense of accomplishment.
AP format for the masses was new in 2008 or 2014 if you didn't do Pathfinder.
It's not a new concept now.
