I can't think of any for 3e. I think my group just moved away from module-based campaigns. In OD&D, it was Keep on the Borderlands, the first module I ever owned (or maybe that was Castle Caldwell, but I never played in that one. I got it because the lizardman on the cover looked like Slithe from the Thundercats cartoon.) In 2e, it was Undermountain, Night Below and Dragon Mountain. Boxed sets were big. Each one of those dominated about a year of table time.
But in 3e, the closest thing we came to something like that was the AoW AP, and the group got to about 7th level before we got bored and went on to other things. (Not a knock of the AP, it just wasn't a good fit for our group.) Maybe Paizo's Rise of the Runelords will be an edition-defining adventure (although we really need to hurry if we're going to define this edition while its still in print.)
But in 3e, the closest thing we came to something like that was the AoW AP, and the group got to about 7th level before we got bored and went on to other things. (Not a knock of the AP, it just wasn't a good fit for our group.) Maybe Paizo's Rise of the Runelords will be an edition-defining adventure (although we really need to hurry if we're going to define this edition while its still in print.)