It's obvious you've never played any shooter game. It can't be the norm, because the game becomes completely fucking unplayable with even 50-100ms of input lag.
Total input lag (a time between a button press and an animation showing on your screen) isn’t just 1000ms/fps, although they do correlate.
Outside of the competitive FPS scene, most people using a gamepad can do just fine with extra 50ms of latency. Some genres hold better, some are worse (mouse lag in RTS games feels pretty shit, but no one plays these anymore).
Cloud gaming sucks for other reasons- it’s expensive, it’s fragmented (you can’t just play all of your pc library in geforce now), there are no mods, no real ownership and, more importantly, edge devices like smartphones becoming powerful enough to satiate the gaming appetites of the casual crowd, while the hardcore want all of these features that the cloud lacks. It’s neither here nor there
Current-gent console market (ps6+switch2+xbox series) is about what, 200-250 million units?
That sounds like a lot, but compare this to smartphones. Apple alone sold 247 million iPhones last year. With, say, 3 year average upgrade cadence it's 600-700 modern devices all the time. Add the high-end models of Samsung and other Android vendors. This is still on-device gaming, much less demanding, where people are fine with worse graphics, lower framerate and uneven framepacing, let alone horrible controls most of the time.
And then add even more people with weaker phones, TVs, slow laptops and old-gen gaming consoles. This is the market I am talking about, and I bet for most of these users a bit of an extra lag is completely okay.
Hardware enthusiasts who are horrifies with GTA6's 30fps is a small bubble- most people will happily play it even on the series S, with drops to 25fps (and an input lag higher than most games deliver on GeForce Now)
Mario is even better example as, again, things that are happening in the game are predictable, they just happen tens of milliseconds later than locally. If a game delivers 60-120fps, then playing it in the cloud could be comparable to playing the same game at 30-60fps, and it is FINE. Not amazing- just fine.
What's not fine is the price of the gaming hardware, and some people won't have a choice but to play in the cloud.
Also remember how in the 90s it was considered impossible to create a successful FPS on a console due to gamepad being a bad input device compared to mouse? And indeed it was a bad input device for Quake 3, but then came Halo which was built with the gamepad in mind, with aim-assist and a large change in a game design, and it turned out that you CAN make an FPS for a console, it's just going to be a different FPS.
Maybe if we go into the cloud direction we will see a similar change in a game design, who knows