Almost every buying guide in this category sorts by tank size, because tank size is easy to shop for and it makes bigger look better. Gallons are storage, though, and storage is not capability. A 30-gallon tank attached to a 3 CFM pump still cannot run a 5 CFM tool - it just takes longer to disappoint you.
The specific overbuying we see most: a 20 or 30-gallon compressor bought to run a framing nailer, which publishes 2.5 CFM demand and fires in bursts measured in fractions of a second. An entry-level 6-gallon pancake does that job completely, and the several hundred dollars saved buys a genuinely good hose, a filter-regulator and the nailer itself.
The second most common: a 30-gallon unit bought because painting a car is a someday plan. A 30-gallon single-stage at 5.7 CFM does not run the 6-inch DA sander that bodywork requires, which needs 6 to 10 CFM continuously. If painting is real the purchase is a 60-gallon two-stage machine on 240V; if it is hypothetical, buy for the work you do now.
And the one that goes the other way: a 1-gallon trim compressor bought by someone who wants to use an impact wrench. 0.7 CFM will never run an automotive tool, and no amount of patience changes it. Every page in this section states what its picks cannot do, because that is the half of the information the category usually leaves out.