I've browsed through a bunch of those mods, and I have to say that I'm still not convinced that there is so much to look forward to. It's nothing new, it's nothing "ground breaking" like everyone promised it would be before HL2 launched.
Sure it might take a year or so before potentional mods get out, but I still don't get the vibe I had when I started hearing about mods like Team Fortress, Cry Havoc, Rocket Arena, Counter Strike, Desert Combat and a bunch of others.
Seems like everyone is just copying a movie or something these days when creating "new" mods.