The beautiful aspect of this compared to selling products is that everyone involve know what is expected from each other, the responsibility to fix bugs is established in the beginning, and its very hard to sell someones else mod as your own.
It would be a great thing if Valve implemented a Patreon model for modding instead of direct pay. That would let people get the attention their great work deserves, streamline donations, and not change the nature of the modding community in the process.
A black and white webcomic I read runs a patreon page, and get $3k a month with only 800 patrons. The author was previously unknown, and managed to reach this point purely on the quality of his/her work and the readership it gathered. Looking at some of the major skyrim mods with millions of downloads, I suspect they could easily gain more than 800 patrons.