I have a home campaign world, and I really only want to run adventures that fit into it fairly well. But that still leaves a lot of room for published modules. I've used them for years, and I'm sure I'll keep on using them. Phandelver is a good example. The town of Phandalin got pulled out, remapped, had a few new NPCs added to it, a shift in setting from "a volcano erupted here" to "the dragonwar ended five years ago here". The town mayor became a political appointee of the local Count, and has now been replaced by Sir Whatsisface who was rescued by the party - who were the Count's hirelings. The Redbrands were a mercenary group during the war, and they settled here in Phandalin when their trade collapsed after the war, and took up banditry and slaving to make ends meet. Wave Echo Cave, Cragmaw Castle (aka Caer Mawr) and a couple other sites became ancient ruins of the previous empire, and Venomfang is the youngest offspring of a dragon killed by Greenvale's armies during the - you guessed it - Dragonwar.
So yeah, a good adventure module is good fodder. Some get ripped apart and used piecemeal, while others get major plot points but not the structure of the adventure re-used, while others the "dungeon" gets used, but not much else.