Look at the cfm rating for the compressor and the cfm for the pneumatic tools you plan on using. A small tank can be exhausted fast, and a low cfm compressor will take more time to recover.
I know things don't always go as planned, but think future needs of compressed air.
I tried a little twin tank compressor once that was about the size of a pancake compressor. For small jobs it was fine - but can be frustrating when the workable pressure fell below the tool effective operating threshold and having the wait time to continue for another spurt. Also, I was working that poor little thing hard.
Small compressors for smaller jobs/consumption I think is fine, takes less room and is portable.
Also, if something doesn't meet your needs, take it back and upgrade during acceptable return policy.
I go in usage spurts depending on what I'm doing. I have an old Jed Clampit compressor - cast iron twin cylinder I been using for years. Looked bad when I got it (still is) but it's been a work horse. I've had it go for hours on pneumatic sanders and it smell cooked many times. I added 2 extra tanks (about 35 gallon each) to it for some run time volume - actually because I got them cheap and put them to some use.