I’ve played and DM’d a lot of adventures over the years, and pretty much every single one of the classics and I think there’s a lot of nostalgia working its charms in regards to their status. My best two player experiences were Dungeon of the Mad Mage and Temple of Elemental Evil. Both of them needed lots of love from the DM to make them work.2nd Edition wasn't a golden age for adventure design, either. There's a reason those "best adventures of all time" are overwhelmingly dominated by adventures from 1st Ed and older - for all of their flaws, that's as good as it gets. Each edition since has had one or two classics (which were themselves often remakes), a bare handful of good adventures, and then a load of... other adventures.