As a guy who has remodeled huge chunks of my home (and used to airbrush professionally)...
Tool-sized compressors are pretty dang loud. One solution would be to get a compressor and an air tank; fill the tank in your garage. You would want all of your fittings to be very airtight (valves, hose connections) or it will just leak out overnight.
In the airbrush days, many artists used scuba tanks, which they would have refilled.
An airbrush compressor may not have the "oomph" you need. I have one (somewhere) and it really wasn't good enough for airbrush art. The spray (even with thin dies) was a little too grainy, not atomized enough.
With any sort of compressor, you'll need a hose (a coiled hose is probably best), a system to hang it and keep it out of the way, an air blower attachment, and all the fittings. And with any compressed air source - unless you live in the desert - you'll definitely need a water separator. Even on dry days in Dallas, my compressor squirts a lot of water vapor. Keep in mind the air tank is holding a roomfull of air (and whatever humidity is in that air). Also, compressors with oil-using engines (vs. teflon piston rings) deliver a good deal more air for the buck - but engine oil can find its way into the tank - not harmful to your framing nailer or impact wrench, but not good for art.
All of that said - the convenience of the cans is huge compared to the above. They're delicate tools for delicate work, vs. something made for removing cylinder heads and building roofs. I'd think it's overkill, unless you have a large darkroom running 8 hours a day, in which case you'd install a compressor in a dedicated room, with all the filtering bells and whistles and a system to deliver air to work areas.
I used to use a small air compressor from a big-box store. Actually still have it. Right after spending quite a bit of money on nice hoses and fittings to plumb the air into my newly constructed darkroom I was enlightened to the idea that blowing air off of negatives, film holders, etc. just pushes it up into the darkroom atmosphere where it inevitably settles on something else where it is not wanted and causes problems. So I adapted flexible plastic hose to my vacuum easel in hopes that the dust is now sucked out of the darkroom. The vacuum, by the way, is outside the darkroom. I fitted a small tube and brush intended for vacuuming computer equipment onto the darkroom end of the hose.
I am working with the hair dryer of my wife. It's cheap and perfect for this use.