Still, I do think the idea of allowing modders to sell their creations is good! I just think maybe we should try to come up with some solutions to these problems, if they really are pertinent.
I guess that you are a pretty busy person and probably just glance through the entire thread since you miss quite a lot of important points in this regard that already have been stated in various forms by a lot of people, me included.
However, since you are quite polite and I assume, not baiting, let me reiterate several key points.
First off, modders who want monetary remuneration already have some ways to get there prior to the Steam workshop fiasco. The most popular is the Paypal donation link that you can put the link in either the mod page or your own account page in any one of the major modding sites such as Nexus, TotalWar forums, Moddb or Loverslab. The second most popular one is a setting up a Patreon where people can donate to the modders for continuing to support and improve their mods. The paypal method have already existed for more that a decade already while the patreon method have in these recent years gained popularity as a lot of creative people on the internet use them such as comic artists.
Understanding that donating 100% to the modder bypass various legal issues as making money with a mod is illegal and risk Cease and Desist lawsuit by the companies involved. To iterate, donating to someone involved in a mod is ok, donating to and for a mod is illegal.
Now, why do you and many people never see a donate link before despite some modders using them? The answer is obvious if you think about it for a moment, don't you?
It is because the best mods, which most people are only interested in, are made by a collaboration of a lot of passionate people who love the game and want to make it better in various ways. Most of them, myself included, aren't interested in monetary remuneration when we are modding.
The reward itself is playing through the game with the mod and seeing things worked as intended, for me. For others, the comments praising everyone involved feels great.
Would I get butthurt if someone involved in the mod setup a Patreon if he/she believe she had contributed a lot to the community and will continue to do so?
No, in fact, you will find most such Patreon sponsors to be the other modders themselves, who know how much work is required.
So, why is Steam Workshop fiasco an issue?
The simplest explanation is that it allow mods to be sold as third party DLC for the publishers, with a lot for issues including publishers overruling modders control over the pricing and bundling, publishers will get lazier with quality control for their game, people selling a reskin version of a free mod and may DMCA, with the publisher assistance, the original version for fear of lost of profit if people figure out there is a free version available and such.
For more information about this fiasco, I recommend you start reading from page 1 of this thread carefully, as a lot of modders and others have expound on the topic pretty clearly already and like me, have zero interest of repeating the same points over and over again for people who believe that they are smarter and know more about the topic than other people yet not interested in finding out about the topic before giving their opinion.