Define your needs vs wants (cost, size, power needed, etc).
And remember the mantra - Good, cheap, fast. Pick any two.
Then pretty much just go get the 'biggest' air compressor (motor, pump, and tank) you can fit and afford.
Cause almost no one ever says 'Gee, I should have gotten the
smaller air compressor'.

(short of someone waaaay overbuying for their needs and electrical power available, like buying a 15 HP continuous screw compressor to fill a bicycle tire and all they have is a 120V wall outlet for power).
Also don't forget some sort of air-drying 'system', cause all the air that gets compressed brings with it all the moisture that was in the air in the first place. And moisture in the air stream is a bit$h for a media blaster or fine spray painting.
And no, just putting a 'filter' in the air piping is almost never enough. The typical air filter just traps
droplets or solids (aka not vapors). So you need a way to cool the air down and then run an air dryer (or dryers) of some sort (refrigerated or dessicant or some combination).
The CFM needed depend on the blast gun/tip being used. Smaller tip opening and lower air pressure means slower working and a smaller needed CFM. Bigger tip opening and higher pressure means faster working but more CFM needed.