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.