Adventures that I've run and enjoyed include Lost City of Barakus and Lost City of Gaxmoor (Heracles' stats need to be heavily nerfed, though - Luke & Ernie Gygax wrote a fun module but the 3e stats are not good).
Adventures that look good which I haven't run yet include Vault of Larin Karr, Siege of Durgam's Folly (by Mearls), and Legacy of the Savage Kings.
Adventure that nearly killed my campaign: Necropolis.
Adventure that looks too flawed to run as written: Hall of Many Panes. I'd like to adapt it and still use some of the Panes for a world-hopping game though, but many of them are just puzzles set in generic fantasy worlds, not unique exotic locations like I expected.
Adventures that look good which I haven't run yet include Vault of Larin Karr, Siege of Durgam's Folly (by Mearls), and Legacy of the Savage Kings.
Adventure that nearly killed my campaign: Necropolis.
Adventure that looks too flawed to run as written: Hall of Many Panes. I'd like to adapt it and still use some of the Panes for a world-hopping game though, but many of them are just puzzles set in generic fantasy worlds, not unique exotic locations like I expected.