I like campaigns that cover 3-4 levels. That means you can get into a good storyline, have some epic events, and then move to something different. I think original D&D had a number of short campaigns (Slavers, Giants, Drow, Saltmarsh/Underwater, Hommlet & Temple, etc). Some were a bit longer...