I've only ever seen 3 modules that appealed to me enough for me to want to try to run them. Two were freebies from WotCs webpages, the third one store-bought.
The two mini-modules from WotC I melded together; mixed them into one and ran them in one session as a sidetrack-adventure in a longer campaign. That was ok. This was shortly after the release of 3rd edt, my experience with RPGs was limited to playing in ONE campaign for a few months, so I downloaded EVERYTHING I could find on the web! I was already DMing my first campaign in my homebrew world, and I needed all the inspiration and input I could get back then...
A couple of years later, after three campaigns had ended in TPK after 1-3 sessions each, I was really struggling to come up with an idea for a forth campaign. So all of us in the group decided to try this brand new WotC-module; Return to the Temple of Elemental Evil. It ended with a TPK the second session...
There was picking the campaign up again with new characters; friends and relatives of the first group trying to figure out what happened to them was the idea, but I refused to do it. Frankly, running the module bored me immensely!
It's not that RttToEE isn't well written and full of cool ideas, it's just that there was nothing for me to do... Instead having my creativity challenged, I felt my role was reduced to "the guy who looks up stuff in the book".
I've never even looked at a module since that. It showed me that for me, the fun of DMing is in the creative process. Plus, a lot of the modules I've seen (before giving them up) seem to require some pretty heavy railroading of the PCs, so even the players are robbed of their creativity...
On a side-note, while running RttToEE I noticed that the author was the same guy that wrote those first two modules I'd used. I was mighty impressed; of all the modules I'd looked at, the 3 I'd actually wanted to use were all written by the same guy! I remember thinking I should keep an eye out for more of his stuff. Then I noticed I already owned three books with his name on the cover...
