I have a PS3, Xbox 360, and a Wii and they are all collecting dust.
I am primarily on Steam and have always wanted to be able to play my same Steam games on my TV.
Thanks to Steam Big Picture Mode, WHDI, and USB Sharing, I stream my games from my office to my living room and play using a 360 controller. Or even multiplayer using two controllers with a friend.
And for games like Counter-Strike Global Offensive, I just stay in the office.
No need to have two computers, synched save files, or consoles.
To sum it up: I hope that Steam does away with consoles.