It really is negligible. The controller is a wifi controller connecting directly to the player's Stadia instance which helps combat latency.

As for a game like SF, I am not sure. They have MK on Stadia and I hear people enjoy it but I don't know what the latency is like.