I don't think i myself am going to use any of that in the foreseeable future, but i'm more excited for what this could mean for the gaming industry in general - more PC oriented games, better support for those and overall less of a barrier between consoles and PC gaming - all of which would be good for me.
And, when they inevitably reveal Steambox (worst kept secret, ever?), that, in combination with SteamOS, sounds like the sort of console i can see myself actually getting someday.