I’m buying a new compressor soon as well. I want to be able to spray clearcoat and use air tools, so I’m getting a big 220v dual stage of some kind. Basically “shop air”.
Check out https://www.aircompressorsdirect.com if you haven’t yet.
I have a little porter cable pancake compressor that I’ve used the hell out of for the last ten years. I use it to shoot nails, inflate tires, blow gun, etc. it’s great because it’s easy to lug around.
Harbor freight is great for some things but I’ve had trouble with tools. Just burned out a second hammer drill. Won’t buy another from them. Haven’t been brave enough to try their compressors.