Steam Workshop is also part of Valve's "walled garden" strategy. Say that you bought a game off GOG and looking for some specific mods. If they aren't on Nexus, Moddb or some other website but only on Steam Workshop (where too many are), you won't be able to get access to them. So you either enter Steam's garden where they will try everything to make sure you won't leave...or you are out of luck.