It's interesting that Source doesn't get a mention here, when it used to be a rather popular engine. Given unreal is second, it's clearly not an objection to closed source engines
Some of these mods turned into games later (Chivalry, Black Mesa, Insurgency come to mind) but without investigating I'm not sure they even use Source anymore.