ofcourse we got many people working on mods, but how of these mdos will actually come out? as we know, many mods never get that far, after awhile they just give up, and the mod is never completed.
Eh, doubtful that most of them will ever see the light of day. One mod that seems to have a very good chance though is Insurgency. They're already taking FULL advantage of the SDK released so far, and I believe have gotten their weapons, maps and models into CS: Source.
Many won't, but some will. Another that most definately will is Neotokyo.. when HL2 was delayed, a smaller UT2004 version was developed and released as a proof of concept, and now it's going back to HL2. With so much work done already, it will most definately be completed. -> www.neotokyohq.com
Probably about 2% of all major mods will see the light of day. Alot of smaller mods will be released within days of HL2, things like weapon mods and AI mods.