I have a makita oiled air compressor that has two small holding tanks, is of a cast-iron design, and works quite well. I run my finish and frame nailer, as well as palm nailer on it, and its design is good enough (holds enough air) that when set to 85 PSI, it doesnt cycle more than once every minute or two under heavy use.
It is heavy, but what air compressor isnt.
If you want a good one, Id say to buy an oiled compressor. I run it through a coalescing filter and a dessicant filter, fill an 11 gallon portable air storage tank, and use that to fill my tires, works great. A cast iron oiled compressor will work indefinitely, and provide great service.
If you are afraid of an oiled compressor for whatever reason, Id buy a thomas compressor. That is what I use to provide shop air in my lab (to run my chromatograph and feed air to some ovens as necessary). It cycles, runs great, has for years. Thomas apparently makes sme of the best non-oiled compressors. Some are rated at up to 100% duty cycle.
Of course you get what you pay for. A good quality oiled unit, or a thomas non-oiled unit will last and be trouble free. A Harbor freightmay only last a year or two of intermittant use.
If you do go oiled, after breakin, be sure to put synthetic compressor oil, like the amsoil product in. It makes the compressor head run notably coolr.
JMH