For a small counter, the manual-fill tank models make more sense than a water hookup, since plumbing one in adds cost and complexity you probably don't want in an apartment. On noise, they're not silent but usually fine in a kitchen. Maintenance is the real issue: you have to drain and dry the reservoir regularly or it does get gunky, so factor that into the routine. Given your tiny freezer and weekend hosting, I'd look at drain-and-clean ease first, then cycle time.