I picked up a 5gal 1hp 120V compressor, oil pump at 125psi max on a half price sale to inflate tires, dust brakes, etc. I thought about getting a nice 25gal tank with a 12.5CFM rating that was also on sale for a not so great $800 (Canada overpricing...). It wasn't available in a vertical tank design so not only does it cost 8 times as much, but it would take up four times the garage space. The downside is that I'll muscle my automotive work using hand tools as the compressor has a meager 2.4cfm rating at 90psi. Shockingly it's quite quiet and 5gal size is great for topping up tires (95% of it's use!).
I had a screw compressor in my old shop. I paid a LOT for it, it worked flawless for many years at 100% duty cycle. They run 3-4 times more than a cast iron pump compressor. It pays to shop around if you want to go that route...