Does tank size matter more than CFM?
Short answer: No; CFM decides how much air the pump makes, while the tank only stores a buffer, so a big tank on a small pump still runs out on continuous tools.
The tank is storage. It lets a compressor supply short bursts that exceed what the pump produces, then refill between uses. That is why a large tank helps with impact wrenches and blow guns, which run in bursts.
For tools that run continuously, such as sanders, grinders and paint guns, the tank empties and the tool then lives on whatever the pump can produce. If the pump's delivered CFM is lower than the tool's demand, pressure keeps falling regardless of tank size.
A larger tank does have benefits. It reduces how often the motor starts, which helps motor life, and it gives moisture time to condense and settle so you can drain it. The best setup is a pump sized for your continuous demand plus a tank sized to smooth out bursts and starts. Drain the tank regularly, and never modify or weld a tank; a damaged or rusted tank should be replaced.
General guidance only. Follow the vehicle and tool manufacturer's procedures, and confirm vehicle coverage on the tool maker's list before buying.