Nellisir
Hero
I can't speak to majority. But I am very much one data point in your favor.
I stopped subscribing a year or so ago, but I own #1 through 78 and I've run three paths.
In zero of the three cases did the story cling to the adventures. Obviously they tended to veer back, thought 2 out of 3 went so far off track we just never went back. (this is a good thing)
I also steal characters, bits and pieces, plot points, and whatever other inspiration.
WotC, or maybe TSR, did a study 15 or 20 years ago. Something like 75% of the people who bought Dungeon magazine never ran a single adventure from it. They just read it. And I was one of them. I steal ideas, I steal encounters, I steal maps, I use them as a guide to balancing my own adventures, but I never ran an adventure from it, and I've never really run a module.
What the Adventure Path supermodules miss is that it's much easier for me to spend $5 or $10 a month than it is to spend $50 or $75 once a year, particularly when it's on an elective basis. Put Dungeon out monthly, and I'll buy at least half of them in a year. Maybe more. Put out two supermodules, and it's unlikely I'll buy either one.