Honestly, you can say what you want about the quality of specific products, but on the whole, 2E was pretty much the golden age of D&D in terms of settings and fluff. There were definitely some questionable decisions with the rules themselves, and I imagine most (who were playing back then) would place the golden age for adventures at around a decade prior, give or take, but between all of the setting sourcebooks and the monster ecologies articles in Dragon, there was practically no end of material to use either whole cloth or as inspiration for homebrew.
Granted, this is only when considering 1st party. The OGL definitely changed things in terms of 3rd party options.