I don't think it really matters as long it's thinned enough to spray. I spray Tamiya gloss colors and clear thru my old Passche H airbrush.
Smaller needle diameters tend to be used for narrow fine airbrushing techniques such as for mottled /camo schemes without masking of WW2 Luftwaffe aircrafts, armor camo, etc….