While consoles will always have their strengths with 100% compatibility, works straight away etc I think steam on pc comes close to providing a console like experience for downloading and playing games.
1. Games are always available for download, on any pc with your steam account setup
2. Game patches are downloaded automatically
3. With valves new cloud system, game saves will also be available to download on any pc
4. While it won't help out with installing the latest drivers, it does warn you if they're not up to date and a link to the manufacturers website, although i'm not sure if this works with all games. I don't think Steam can help much in this area though, Nvidia, ATI and all the other companies need to pick up the slack.
5. Steam has a large growing library of new and old games, with a metascore on most games and easily accesable demos and trailers.
6. Steam also regularly runs price promotions on certain games, and offers preloading on certain games so you can play it the minute it comes out.
And to top it all off with the new steamworks package, you can make your indie game available through steam, with all the advantages it provides. Try doing that on a console.
I think consoles will always have their place, but I also think in the future the issues with patching and hardware compatibility will be greatly reduced on PCs.