Stumbled into it tonight. Very cool idea. Spares me from having to route through mod managers, just to get some specific mods I'd like for a game.
I LOVE the idea that you can subscribe to them.
For example. I subscribed to the "Enhanced Blood" mod. So every time I go to play skyrim, Steam will search for any new versions of that mod, download, install them, and afterwards, launch the game.
With this in play now, I feel as though devs will be encouraged, or more open minded when modification is the subject of matter in their new games.
What do you all think of Steam Workshop?