No space here for the spray booth, etc, so I haven't used them for a couple of years. But they are great for:
Undercoating figures and resin terrain- and you can pick or mix the exact undercoat colour you want.
Base-coating and some detail work on vehicles, aircraft, equipment, heavy weapons and terrain items.
Cam patterns and weathering on vehicles and aircraft.
Varnish coats.
I tried, and failed miserably, to use my dual action one for shading/highlighting figures.
I've found my airbrushes are less messy, easier to clean up after, more controllable and cheaper, in the long run, than rattle cans (especially hobby rattle cans). But there's a bit of a learning curve, so I understand why some people prefer rattlers.