The problem I see with the perception a lot of people have with Stadia is that they compare it to a traditional console launch. With a tradicional console launch, the library of games, price, how fast you can sell them, are extremely important. It is obvious that if a console fails on all of these points at launch, retailers will stop accepting it. If a console is not selling the game stops right there.
Stadia in comparison was launched as an MVP, designed to grow from a basic service with the minimum required to work. This is not like a console that you buy and if it sucks you sell it and it is very unlikely for you to buy it again. Stadia as a service will simply keep evolving whether you liked it or hated it at first. Today you might have terrible latency because the closest data center is too far away, that could change in the following months/years if they open one that is closer to you. Today their game library might suck and tomorrow they might have most of the games you would like to play. If they do get to improve the service enough in order for you to go back, you don't have to buy a console in order to use the service again. If your neighbor buys a game on Stadia and you try it and it works perfect for you, right there you just go to the Stadia app and buy the same game to start playing it in seconds. Compared to consoles, the friction of entry is almost non existent.
You made a lot of interesting points, but I wanted to focus on this portion about the comparison with a console launch. While Stadia is a different value proposition than a console launch, I don't think ppl are wrong to make a comparison this late in the generational cycle. Stadia isn't operating in a vacuum and so when you can't play many games on a service that's supposed to be the future after 6 months, ppl are wondering what's going on. Unlike console launches, they don't have to create new content, all they had to do was make sure all the third party content was available. Disney+ didn't launch with 30 movies, they threw everything on there.
I think the biggest question ppl have with Stadia is why did they launch it at all if they were going to have so few games and the 4k wasn't working? You don't get a second chance to make a first impression, and so I'm left confused as to why Google would shoot itself in the foot like this.