The best published FR adventure in my opinion is N5 Under Illefarn. Basically, it's a intro setting for low level characters (Daggerford Area) with three short adventures and one big adventure. The big one is set in a dungeon but there is a specific mission and three different factions working off each other so it doesn't really play out like your average dungeon crawl.
I'll also second Halls of the High King as being a pretty good one too.
If you're willing to stretch the boundaries of FR, I3 Pharoah, I4 Oasis of the White Palm, and I5 Lost Tomb of Martek is one of the best series of adventures ever written. The original modules were not FR but the the setting was later placed into Raurin, the desert southeast of Mulhorand, and rereleased as the I3-I5 Desert of Desolation supermodule.
The Bloodstone series is pretty good too, if you like high level play. Like the above modules, it was originally generic but the setting was later imported into FR (Vaasa and Damara).