Honestly, for the various jobs you mention, I think a turbine based HVLP fits the bill the best. With a comprehensive nozzle and tip set you can spray anything from lacquer to contact cement…
I’ve painted a single small model airplane up through 90 doors and their frames with mine.
Unthinned latex no problem, and covers beautifully. Since the air is compressing rather than uncompressing moisture isn’t an issue. Also, since it’s warm, the finish tacks up quicker.
Water based, oil based, epoxy. Don’t need a big bulky compressor, just a normal 15 amp 110 volt circuit. Kinda pricey but super versatile.
Unless you’re painting a house or barn, then ya need airless, or super budget minded, then a harbor freight hvlp conversion gun, highly recommended.