This can do a lot of good, but people have taken it entirely the wrong way. The thing you have to bare in mind is that most of the big mods aren't going to even be on Workshop, thanks to file size limits and the lack of customization. On top of that, Skyrim mods you pay for on Workshop are available for free on the Nexus. And all you have to do is download their mod manager, which is super easy to use and set up, and it's all entirely free. Wet and Cold, and iNeed's author has even done a sort of exclusivity deal with the new versions of those mods, keeping them Workshop only for 30-60 days, and then will post them on Nexus.
I am however curious to see if mod piracy will become a thing.