Well after hearing about the few good modders actually liking the idea but still don't think its the "best idea", I could say that paid mods could work. If they actually offered mods that weren't such obvious cash grabs, or like that one asshole who turned the free version of a mod into a "trail version with a 4% pop up ad chance"; that dude is a fucking asshole for doing that.
And honestly I wouldn't mind paying the modders for their hard work, but there's alright a donate button on The Nexus that gives them a big and fair cut of the profits; but no one uses it is the problem. But the whole idea of paid mods is taboo enough already, and I know that Bethesda and Valve had good intentions with it (letting modders that deserve it finally getting paid). But too bad that: 1. They're a company that needs to bathe in money 24/7 regardless of what they say. And 2. The internet is full of scheming, unoriginal hacks that would rather ruin a system to make a quick buck with clones of existing mods or scamming people out of their cash.
Oh and Bethesda's hands-off moderation of the workshop was literally the most stupid fcuking thing I've ever seen.