I like Red Hand of Doom, Exp. to Ravenloft, and Slaughterguarde quit a bit. The Twilight Tomb seemed very "flat" to me, but still very useable.
Besides, I never look for a module to be great, I just expect it to be solid enough to be great when I run it. Which 90%+ of all the modules I have bought have been that way. So I have been happy/satisfied where I have seen many others say they hated it.
Even in 2E days I hated the whole "Avatar" story arc, but I still bought the modules because there was still plenty of info in there for me to turn into good adventures. Even after throwing out the Avatar trash.
I like Red Hand of Doom, but not because of the story it has written into it. Its not something I can use without heavy modification, but I like it because it also gave me tons of inspiration for other adventures. That is what makes a great module for me.
That is why I prefer Necromancer modules over many of the Goodman and WOTC modules.
Every Necromancer module (Yes, I have bought every Necro module) not only has a good/useable "core" story to their modules, but they always give me tons of ideas for different directions to go in as a separate adventure, or to continue with when the module adventure is over.
Many DCC's and WOTC adventures have not been that inspiring to my imagination. They do have a fair number that do though. In fact, after DCC 10 or 11 Goodmans DCC's have been much more to my liking.
Most of WOTC's new line of modules have been to my liking as well. Lots of extra adventure ideas, with Red Hand of Doom and Exp. to Ravenloft being my favorites so far.
So I agree that with regards to modules, WOTC is not only not "flavorless", but it isn't "crap" either. They have been very on par with Necromancer and Goodman, which is great for me because I like buying/collecting adventures. Even the Eberon adventures, even though I don't like Eberron itself.