If you can, go to an art supply store and talk to them about it. There’s a lot of details that make a big difference and depend on you and what you need. (No, big box craft stores like hobby lobby do not count)

That said I have a couple iwatas that are nice… finicky…I’ve used paasche as a good place to start- you’d still need a compressor, mind you, and if you’re not looking for a “get your feet wet” kind of option, I would suggest looking at something more like the Iwatas.

The good news is that once you have the full kit, you can upgrade parts as necessary

Over the years, the passache has been a good reliable airbrush, but the Iwatas were- if some what finicky- more precise and tight.

I’ve subsequently picked up a few holders and the largest decision point is pot or jar. The pots let you tweak color as you go where the jars are great for pushing volume to base-coat large pieces (or lots of smaller ones,)

If you find a good independent art store, they may give you more specific advice… and possibly trying different holders. There’s a lot of personal preference though.

Edit: looking at the Iwatas kit - you don’t have to buy a kit, you can mix and match to get a set up that meets your needs but it’s a simple kit that has “everything”.

Also something to consider is a spray booth. I would suggest just making one- a box fan, a home hvac filter that fits it, and some foam board (or when you like the design, corrugated plasti-board) cut to shape.