I had really excellent adventures crafted from the ideas and game material found in sourcebooks like the grey box, The Savage North, Old Empires, City System, and The Unapproachable East.
I definitely recall taking some parts from curse of the Azure Bonds module. I also have fond memories of playing through a version of Under Illefarn. I don't recall much from the Daggerdale trilogy, and the Avatar trilogy was...interesting, but I wouldn't want to do it again. For those that don't recall, that was the story that ushered the transition from 1st to 2nd ed. Yikes.
It's interesting that nobody's mentioned the mega-module CoTQ. I know that there have been a lot of people played through it.
Dungeon magazine has had their share of FR modules printed. I recall playing one, perhaps an SKR, that was a low level adventure set in the Dalelands and was a two or three part adventure that ended with a Count of some sort.
Ed did a couple of modules for the FR which a pilfered for my campaigns. The Halls of the High King and The Haunted Halls of Eveningstar. Those were both pretty good.
I've just recently picked up the new Shadowdale hardcover module and have really enkoyed reading it so far. I would happily run it for a module/campaign.