I think it's a neat idea, but computing is cheap nowadays. When you have a nice screen, battery, and enclosure, throwing in some compute isn't a huge deal.
As you mentioned, I think this makes it redundant with the cloud when you can make thin-ish clients for everything, like Chromebooks, or Apple and Microsoft's initiatives to seamlessly transfer your workflow from one device to another.