Add "Doom of Listonshire" by Necromancer Games.
From Goodman just about any of them are "good", just none of them I consider to be outstanding except the Devil Lich module which was just reprinted again.
Another kind of exceptional module from Goodman is DCC 29. DCC 1 through 5 are pretty good as well. I think you'll find any of the Goodman modules to be at least "OK", several you may end up liking a lot.
As for NEcromancer, I second the recommendation, or add, to the following:
Tomb of Abysthor
Vault of Larin Karr
Morrick Mansion
Lost City of Barakus
Grey Citadel
Trouble at Durbanford (a seriously under appreciated module)
Bone Garden
Rappan Athuk, either version
Doom of Listonshire
Six Sphere of Z...(however the heck you spell it)
Coils of Set
Family Affair
Hall of the Rainbow Mage
Crucible of Freya (and the free Wizards AMulet downloads)
Necropolis
Plus there are no NEcromancer modules that I would rate less than "good", with the exceptions of the Zayene (sp?) modules, and Durham's Folly (sorry, I hate "clockwork" type creatures)
Plus I recommend the Freeport modules from Green Ronin, the Coin Trilogy from Kenzer, and Paradigm did several good ones but I am unable to recall their names right now.
I agree that Red Hand of Doom is an excellent module and Slaughterguarde has the ability to be a lot of fun as well. I am also in the camp that likes the revisit to Ravenloft, a lot.
As for the Paizo AP's I like them, but I hate them as AP's. Still plenty of great material to pick and choose from even if you don't run it as the backbone of your campaign.
Don't leave this up to a vote. Find them and buy them as your able to afford them.