Valve said that Steam Big Picture Mode is close to release. Hopefully in addition to getting developers on board with including an option for a console like UI to games they can also get developers to include an optimized PC UI so we don't have things like the Skyrim UI on PC. Probably a pipe dream, but I can hope.
http://steampowered.com/steamworks/thebigpicture.php
Here's a link to their Big Picture Mode info. Not a whole lot of details, though hopefully it allow Steam to connect to your TV through your wifi network allowing a sort of local OnLive type system.