I'm not so sure about that. I see no practical reason for bigger blocks. Buying coffee on chain was never a realistic expectation, and I'm pretty sure Satoshi said a second layer would be needed for that.
Idk what the physical limit of memory is, but its out there somewhere. Personally, I'm not willing to buy more, more often than every few years. I'm already pruning my node, when its even working. I'm not a technical wizard, so I'm probably representative of what people will actually do. Devs always seem to have some unrealistic idea of what will happen. We need more nodes, and we need better nodes ; what bigger blocks delivers is fewer nodes, and worse (pruned).