The Banewarrens is probably one of my most favorite adventures of all time, I rank it up there in terms of fun with the Giants series. Intrigue, urban setting, betrayal by allies, a large logically designed underground complex where often times the biggest challenge are rival groups exploring the complex itself, and a lot of different changes of scenary that tie all together into a nice climax. I personaly am a big fan of opening scenes wether for movies or modules. Banewarrens has one of the best "opening" scene encounters I have ever run. Cant reccomend it enough.
Age of Worms. Whispering Carin is a genius adventure. The high level segement of this path is just fantastic. I yoinked many things from it for my home brew, just great stuff.
Red Hand of Doom is great up into the 3/4 mark. I think it peters out at the end, the big bad is really more denoument. Nice production values, but it suffers from the classic WOTC problem of having all stats in an appendix in the back. I hate this wrecks it for me.
Sunless Citadel is like Palace of the Silver Princess to me, a classic entry module. Like many people, we played this right out the bat when 3e came out. Wasnt terribly impressed at the time, however when I ran my first self made adventure for 1st level characters, I appreciated the Citadel's design much more.
