> On balance, it seems we just swapped one set of problems for another set of problems, and we haven't really gained all that much in the end.

That is the crux right there. And some people need one set of problems fix (so do the cloud) and some need a different set (so do on prem).

I very much prefer on-prem, but for some sets of problems, the cloud does make sense.