I think it's a bit simplistic to act like money won't change anything community-wide, especially with regards to cooperation between modders.
I liked the example someone gave before of Wikis - everyone contributes for free because the expectation is that everyone else is also contributing for free, and whatever you put in is being paid forward and returned to you in the form of shared knowledge and a more comprehensive Wiki.
How does that change when some people contribute for free, but they learn that others are getting paid? Rationally their reasons for contributing shouldn't change ("I'll still receive something in return"), but people have a definite bias against contributing when they learn others will receive more for the same or lesser effort. "Why should I contribute for free when someone is getting paid to do this? This takes up my time and effort; I don't want to be a chump and get taken advantage of. If they're getting paid, they should do the work; I'm not bothering. Or, I won't bother unless I'm getting paid too - fair's fair."
So you can have situations where modding communities that were formerly pretty free with exchanging information, "loaning" mods to others, collaborating, etc. become divided, distrustful ("Are you trying to make money off this?"), and reticent to contribute - the past two days provide a really stark example of that.
I don't buy the line of thinking that money is just another harmless incentive like recognition or thanks, and everyone's going to be fine with some modders making money off of a shared knowledge pool while others don't - clearly, many people aren't okay with it. It can be a powerful incentive, sure, and maybe in the long run you could argue that it will ultimately benefit mods (if implemented and introduced properly, which I don't think Valve has done), but for better or worse it clearly changes how modders will interact with one another.