Streaming games is useless for any game that has a moderate amount of action/platforming elements. I could probably play something like Disgaea or Persona like that, but that's it.

And before you ask, yes, I've tried it. I played the witcher 2 streamed over a 40/40 Mbps fiber optical connection. There was still noticable input lag.