Sounds like area sourcebooks are the way to go, though I still miss the definitive adventure module. When I picked up the newest module, it was just a lot of fun looking through it (only if I wasn't going to be playing in it, of course), looking at all the neat pictures, and maps, and ideas. To this day, I will occasionally grab one up and look through it, invariably getting re-energized and motivated in some way, for more gaming.