I am with you. I think the actual use case for a casual gamer is absolutely there, running and playing decent games from many different devices, without having to invest in and own a more expensive PC equipped with higher end internals (graphics, etc.).

I am worried about Google's ability to actually execute and make this successful, however (And that does give me hesitancy to buying some of the games that are on there, because they aren't transferrable to somewhere else if Stadia is shut down).

For one, with this in-house studio model, they haven't even shipped a single game yet and they're pulling the plug on the approach. That just seems like giving up before they've even tried. But Ok...

As others have said, the single biggest issue with Stadia is not that it doesn't work wonderfully (it does), it is the extremely limited catalog of games available that needs to be addressed. If they can successfully address that, then they really do have a pretty sweet offering that will be tough to beat.