If you live in a major city (i.e. close to a datacenter) the latency is perfectly playable. Especially when you consider that the market for Stadia is not counterstrike pros who care about every millisecond.

I really believe that the reason Stadia hasn't taken off yet is the limited game selection, and non-existent marketing. Technically it's really good, but there's only like 3 games on there that I have even a vague interest in playing.

Everyone hates epic for buying out exclusive rights for a bunch of games, but it's certainly a strategy that has worked out for them. The Epic store is now a genuine competitor to Steam.