The main thing I can see with this technology is this: single player games will perform worse, but online multiplayer will perform better. I mean, in a lot of multiplayer games, someone's console is often the host. Obviously, stadia is going to be better than this. Even a game with dedicated servers is not going to be better than Google's sytem though. On top of that, platform neutral means that you can just play with whoever you want regardless of device.
On the other hand, I just don't see how single player games can match running directly from a standard console. Internet connections can always have problems no matter how good their service gets.