I do agree however that Stadia sucked as a product. Nobody was going to buy into their ecosystem if they can't opt to download the games onto their own PCs like Steam. Too much lock-in without that aspect, and without any guarantees that they were going to refund customers if Stadia ever sunk it just made it DOA
Games are already fiddly when it comes to latency. Adding another fiddling layer inbetween just sounds more painful.
Now, different people have different preferences and I imagine if I were a pro online multiplayer guy with 240hz monitor and 10 million dpi mouse twitch shooting against pros, it would not serve as well. But I've played fps games like cyberpunk happily as a single player. They basically have my money guaranteed for foreseeable future.
Moved to a different city, and latency wasn't near as good because of ISP routing, mainly. Still playable, but definite pretiming everything. I think latency there was 50ish ms.
Stadia wasn't laggy or artifacty at all. That is just because you either haven't used the service or you have poor internet.
I played many games on Stadia for a year with zero issues. I perferred over playing the games on my PC as it was just a lot easier / faster, to open chrome and be straight into the game.