If you’re spraying then you either need a really big tank or at least more than a 13A socket (and will definitely want to locate the compressor outside and have understanding neighbours), The smaller compressors don’t deliver enough air to do big projects. You might get away with smaller stuff like motorcycle tanks/fairings one at a time but not a car.
Anything intended for continuous commercial use like spraying will be belt driven which reduces the noise considerably, and >>3000W.
I got mine for £70 from Class Olsen when they were clearing them out, the spec list was much better than the screwfix/machine mart/toolstation/lidl/aldi ones up to about £150. Haven’t tried the included spray gun yet but even by the admission of their own spec sheet it’s going to be borderline (and thus noisy and probably need a lot of sanding and polishing afterwards!). Decent spray guns also seem to cost more than cheap compressors.