I have 2 like you mentioned, a large one, and an inexpensive pancake type.
As for advise on the larger one -- go to a tool shop that sells air tools and paint stuff, and look at the pressure and CFM recommended.
Then decide how many CFM at what pressure, THEN shop the compressor.
FWIW -- I...