There is a reason a lot of people have gone to electric tools for so many traditional air tools, but I don't know of an airless option for sand blasters.
I've come down to three useful sizes for compressors. Fixed 60-80 gallon units, and don't cheap out on the compressor for your tool needs. I'd love to go this route and run airlines all through the house, but that remains a dream.
On the small size a good 2-6 gallon compressor is portable and fairly cheap. Good for small tasks, running a small sprayer / airbrush, filling tires etc. I've not had any issue running nail guns off of a 6 gallon pancake. I have a 2 gallon ultra quiet Fortress (Harbor Freight) which is a nice little compressor. You hear it of course, but I can carry on a conversation in the same room while it is running. Good for really small jobs, I use it in the house for blowing things out, and running an air brush. I also have a 6 gallon Porter Cable ear blaster. Decent compressor, but I hate the noise. One of these days I'll fire the Porter Cable and buy a 6 gallon Fortress ultra quiet compressor. I find the 6 gallon size is still a handy size even with the 30 gallon available.
In the middle I think a good, mobile 30 gallon is the sweet spot. Far less capable than a good fixed unit, but you can find them capable of 5-6cfm @ 90psi and that combined with the relatively large tank will allow it to do an ok job for a lot of air tools as long as you don't have big expectations. Mounted on wheels so not hard to move around, but it is around 150lbs so moving it is not trivial. I use the 6 gallon in the house for anything the 2 gallon can't pull off.
I'd love to have a 60 gal 5hp but just not in the cards. I bought a Dewalt 30 gallon at a Tractor Supply Black Friday sale a few years back, and have been happy with it. Certainly not quiet but not painfully loud like cheap oilless compressors. I compare it to standing next to a diesel pickup at idle. The price has nearly doubled since I bought it, but what else is new.
Personally I'm not a fan of the 10-20 gallon compressors. Too big and yet not enough. It seems like most have a compressor only marginally better than a 6 gallon pancake, the tank isn't big enough to really make a difference and you've lost a lot of the portaility.
Certainly there are niche use cases where a 10 gallon will do the job that a 6 falls short on, but in general use these seem like what you get when you don't want to pay for what you actually need.
TLDR, If you want to do any serious sand blasting, I think you really need to be looking at a good 60-80 gallon compressor.
If you are on a budget don't over look Harbor Freight. Air compressors is one of those items that they tend to do well at a decent price. If you can afford a name brand, go for it, but HF isn't a bad budget option, much better than what you get from most box store brands.