With compressors it usually depends on the tools you're using with them and the cfm they use. A bigger tank will afford you the option to run longer between compressor cycles. For tools like air sanders, drills, and impacts, you'll want a larger compressor with higher cfm output, otherwise the compressor will probably not stop cycling.
I'm picking up a larger one for the shop, but I've got an older craftsman that my dad gave me for running the shop tools, but the pancake style I have runs my nailers just fine. It even does a good job of running my framing nailer without cycling too often (of course could be the speed of the carpenter )
To a small child, the perfect granddad is unafraid of big dogs and fierce storms but absolutely terrified of the word “boo.” – Robert Brault