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