I'm pretty sure that Valve made quite the pretty penny off of just user made maps alone for CS Source?
"Dude check out this crazy game, you can SURF around, kill people, and level up your character for crazy new powers" was the reason I bought CS Source after seeing it at a friends house...
Back in my day, we made mods for fun, and then we used the skills we learned to get jobs doing something corporate.