Didn't 2nd ed have like 2 decent published adventures? The Night Below and Labyrinth of Madness+ Dungeon magazine? The intro to the 1st DS set was ok as well.
There were actually more than two decent adventures in 2E, but - as you can see from the list I posted - they were few and far between. One of the biggest problems is just identifying which adventures were decent, with so many published and the base splintered so much, many of these adventures would hardly have been seen by players and DMs - and certainly not enough to register as decent.
I am very fond of Feast of Goblyns, the first of the Ravenloft adventures (published 1990), which I ran to great effect in a 3E campaign a few years ago. One of the interesting features of the era are the "railroad" plots, but for today's gamer, such plots aren't quite so unfamiliar (Paizo's adventure paths are a case in point). Railroading isn't that bad - but it all depends on how it is handled in the adventures.
I'm also quite fond of how Shadowdale reads - one of the Avatar trilogy, which is rightfully condemned as a horrible series - but the problems are only partly due to the railroaded plot, and much more due to the way the NPCs get to do all the important things (like become gods), making the story much more about them than the players. That's a cardinal mistake in adventure writing. The Dragonlance series (1E) did get that right; the players take on the roles of the heroes, whether as the pregenerated PCs or as their own.
Cheers!