Indeed this is how I feel as well, and I think I have always felt sort of this way, plus it can be insurance from players that have read everything for a game, spoilering the campaign.I think that these days I find adventure anthologies more to my taste than long campaigns -- easy to pick up and drop in, even if you don't like them all you'll probably like some of them, and you get to mix things up a bit in terms of genre or tone.
I like the Ghosts of Saltmarsh approach. A bunch of thematically and potentially narratively linked adventures that can be played through like a campaign but capacious enough to allow for the inclusion of other material and skipping the adventures you don't like without having to change much, if anything.

(Dungeons & Dragons)
Rulebook featuring "high magic" options, including a host of new spells.