I don’t think there is one compressor that makes everything convenient. I think you need a couple, maybe even three if you do offsite work.
1. A small, dual tank, @4 gallon, oil lubricated compressor – builds pressure quickly, fills tires, blows dust off tools, air to clean carbs, runs air nailers, etc.
2. Optional – but something similar that is very light, portable, run air nailers on a jobsite. The above can be used, but is generally heavy to carry.
3. A larger stationary compressor that has capacity to run impact wrenches, air-orbital sanders, HVLP finish sprayers, with a pretty sophisticated filter system.
Depending on your needs, 1, 2, or three. You will appreciate a quiet running compressor in future years. Universal motors mean the compressor is a throw away tool when the motor goes out – try to avoid the universal motors where possible. Oil lubricated is good. Make sure you match the duty cycle to the expected usage intensity.
Hitachi, Dewalt, Ingersol Rand make some nice compressors for homeowners and contractors.
For industrial usage, you wouldn’t believe what you could buy for $20,000.