True. Unfortunately 2nd Ed went through a long phase of "narrative" (railroad) adventures, which doesn't make for many classics.
3e has "The Sunless Citadel", "Forge of Fury" (though that wouldn't be my choice) and "Red Hand of Doom". But it doesn't have a lot of adventures in general, excluding Dungeon and third-party works.
Indeed. It's actually fairly shocking just how little good adventure material we have to show for the past three decades - what's that, half a dozen candidates since the start of the 90s?
I found that those got really repetitive after a while. Pathfinder AP#1 ("Burnt Offerings") was probably the absolute best issue in their entire run (pre-2e, at which point I stopped).
Except that one of the virtues of I6 is its brevity, which CoS sacrifices - this means that things like the card reading now pay off months later rather than hours, which isn't an improvement, IMO.