Connorsrpg
Adventurer
I still like the U (or Saltmarsh) series, even though the 2nd module can be completed in a matter of minutes if approached in the right manner 
I also liked a very old adventure from a White Dwarf magazine. It was more like a large detailed encounter, rather than an adventure, but I have used it a couple of times to great effect. I cannot remember its name, but it involves the PCs coming across a ruin in a wood and throughout the night, hauntings and strange happenings leave a trail of hints to tragic things that happened at the site. Very creepy.
There are few large modules I have ran more than once, and I have never really ran high level or long one's. As I have run MANY low level modules I know them better. Another name I seem to have forgotten (though it has 'night' in it), but was a great basic module involved protecting a homestead from a goblin horde throughout the night. That went on to many other fantastic adventure locales.
For newer adventures, i didn't mind the Forge of Fury for a cool location based adventure. There are others, but I am having trouble gathering my thoughts tonight and don't have any of the books here.

I also liked a very old adventure from a White Dwarf magazine. It was more like a large detailed encounter, rather than an adventure, but I have used it a couple of times to great effect. I cannot remember its name, but it involves the PCs coming across a ruin in a wood and throughout the night, hauntings and strange happenings leave a trail of hints to tragic things that happened at the site. Very creepy.
There are few large modules I have ran more than once, and I have never really ran high level or long one's. As I have run MANY low level modules I know them better. Another name I seem to have forgotten (though it has 'night' in it), but was a great basic module involved protecting a homestead from a goblin horde throughout the night. That went on to many other fantastic adventure locales.
For newer adventures, i didn't mind the Forge of Fury for a cool location based adventure. There are others, but I am having trouble gathering my thoughts tonight and don't have any of the books here.