The community, and modding in general, will not change unless we make it change. Today we saw some really, really ugly stuff. Flaming mod creators, or people who think that this isn't the end of the world, is not ok. All this did is give modders the possibility of getting paid for their work. It didn't eliminate free mods, or other hosting sites, and it's not going to. If modders stop modding or stop helping eachother it will be the decision of those modders, NOT a necessary result of the potential to earn a few $
If you don't like this decision... don't support it. Don't buy the mods, don't use the workshop. Continue on with life as usual. Being a jerk to creators hurts the community in a very real, tangible way, *right now*. Not in a hypothetical what if future, but right now.
As for the 25% revenue. It's not great, and I wish it was better, but it's pretty standard as far as I know. I run an online store where I make an average of about that per sale. I get paid out regularly. In other words, it's not the best deal, but you absolutely can make money from it.