Steam already tried the whole paid mods thing, with little success, or so it seems.
I'm actually not opposed to the idea, as I think paid mods allows mod authors to fund their creativity. The vast majority of mods will likely remain free, but some of the larger mods will have a price. If anything this will incentivize more people to participate in the already huge modding community.