and use some small air tools. Thanks
Small may not mean low air requirements. An air Dual Action (DA) sander (Comparable to a Random Orbital Sander on the electrical side with the caveat that you ALWAYS start the air sander On the piece and stop it On the piece to prevent gouge and swirl marks) will consume up to 12 CFM at 100 psi. Not a big tool but uses a lot of air.
However, one air tool often overlooked by woodworkers is the air drill. Infinite variable speed control and plenty of power. Does not use a lot of air unless using it with a sanding disc, etc (i.e continuously). Things like air ratchets, impact guns, nail guns,etc, don't use a lot of air unless it is continuous for an extended period.
As already mentioned, 7 to 8 cfm @ 40 - 50 psi will be a minimum for spraying continuously, but in reality, 6.5 will work for most furniture work if it has a 20 gal+ tank. That will also be plenty for most intermittent use air tools. Sanders, grinders (except pencil grinders that are comparable to a dremel) and roto-peeners will take a larger compressor. An abrasive blaster can consume an enormous amount of air.
If noise is a concern, cast iron (full cast iron, not aluminum with a cast iron liner) is much quieter, but the trade-off is weight. Oil lube will last longer than oil-less - again, a weight trade-off.
For spraying, save enough when you buy the compressor for a good oil/water separator, preferably with a draincock at the bottom of the bowl for humid days. Use dedicated hoses downstream of the separator for painting to prevent oil contamination (fisheyes) in the finish. If using a lot of rotary air tools (and nail guns) an in-line oiler on a T-fitting opposite the oil/water separator will ensure the tools are lubed without the first spray of oil when you lube them by putting drops of oil in the tool inlet fitting.
Just my $.02 worth
Go