This oscillates every decade or so, and always has. It depends on the relative performance of CPU vs network and so on. Its a yo-yo as technologies develop in unsynchronized bursts and first one scheme works better, then the other.

I see the cloud adding just one new thing - I no longer have to upgrade/manage my personal machine. That's important for some folks and businesses, so it'll change the balance a little.