From the programmer perspective (and this are only my opions) (sorry for poor english):
I think that MS incredible power of cloud has little to offer for single player experience (and content).
As far as we know MS cloud is some kind of dedicated serwers for games, or rather platform to run dedicated servers.
What does game server do for a Video game? - simply runs game engine (without graphics - only a simulation, players stats, players positions, map state etc.). 2nd task for a game server is to synchronize actions of players and make affect one each other.
So.
How on earth does it appeals to SP EXPERIENCE? Some of your CPU and RAM can be saved when console runs your game as a client only, but how much can you gain. 5%? 10%? The down side of this solution is latency. If you expect your game to run 60fps then programmers are left with only 16ms (0,016 of a second) to fit in with all game task until next frame. Go ahead and ping google (type "ping google.com" in your command line). In my case it is like 28ms. So it takes 2 frames from 60fps game to only check whether serwer is alive. You can not build your real time calculations on something like this. Assume that we live in a perfect world. Ping to MS servers is like 5ms. Incredible power of cloud does the magic in like 5ms and then what? Programmers are left with all data processed by cloud and only 6ms to compute the rest. That's not going to work.
Sony on the other hand has way more to offer (it is only posibility and I'm not saying this is a fact nor feature).
When the game runs entirely on server, cloud as a infinite processing power has more sence. Now you don't even need PS4, or PS5. You could play all games using PS3 as a client for GAIKAI. All graphics, phisics etc are generated/compute on lets call it "Playstation Server". Game requires 32 GB of ram - no problem. Servers can be easly upgraded (more easly then 70 mln copies of PS3). Hey - they don't even have to upgrade servers. There is like one server for 10 people (more or less - just as an example). So for more demanding titles server offers room for 5 players.
BTW: For MP games MS dedicated servers sound gr8. Unlimited map sizes and stuff. But I'm hoping for games like WoW - not Titanfall.
















