FWIW, the subscription is optional (with these perks [1]). You can also just buy the game you want to play and play it, no subscription needed.
Also, yes if you already have a huge Steam collection, the thought of buying games on a different store is not great, but I don't think Stadia is aimed at people with a PC gaming rig and 1000 steam games, it's aimed at people who don't have a gaming PC or console, and want to play the latest EA Sports or AAA game. Having to just pay 60$ is far better than paying 60$ + 500$ fo a console + waiting for shipping and installation.
The customer value add of anything on top of that is proving to be extremely thin. I used Now extensively in 2017, Luna extensively this year and Stadia briefly for Destiny 2 - Luna's experience isn't worse enough to provide any benefit to the Stadia lock-in model.
Stadia PM's should really consider focusing more on "Customer Obsession".
Local co-op is a thing in Luna, but I'm not sure about online multiplayer. But in GeForce Now I just used Steam and it worked flawlessly.