Ha, the first thing I searched for on this thread was "raspberry". I just got mine last week. However, there's no way in the world that thing will be able to run modern games.
I have a spare Pi laying around, and I'm hopeful at least. According to the SteamOS page there's a streaming mode where you basically do the processing on your Desktop / Server, and SteamOS just takes care of input and streaming.