I'm not even THAT big of a "gimme my DRM-free games" type guy. I buy most games on Steam, because at least if Steam disappears someday, I can find ways to pirate all those games I bought and continue to play them. Consoles are a bit trickier -- I personally buy physical copies if I can (although that increasingly means less and less, with all the patches and DLC that every game receives after launch, meaning you almost never actually own a physical copy of the complete game. And they even removed all the fun instruction manuals!) But at least every console gets hacked eventually and you'll probably have a way to potentially run pirated software on them in the future.
But with cloud gaming, good bloody luck trying to play the games you shelled out $100 for (modern Canadian pricing) in the future. Not to mention I'm sure we'll find situations in the future where games are patched to remove something that became offensive in the past month, like the big exodus of episodes from streaming services during the BLM protests in 2020.
At least the services where you're just streaming from a generic gaming PC to run your Steam games on can make a bit of an argument for itself that you can download the games to your own computer if you want, and that's just another option for playing them. But who knows how long that'll stay that way. It's quite obviously in the corporate interest to make sure no one ever has access to the game's code on their local machine, and they only ever beam frames to your screen, since that would well and truly stop piracy for good.