Wondering whether it would be worth a try to paint my car myself?

What do you folks w/diy car painting experience – using a spray gun and compressor – recommend for a safe paint to use for the amateur who doesn’t have the self contained breathing apparatus? And which kind of spray gun, the older type or the newer low pressure high volume type?