The irony of seeing this on a civ community message board is. . . illuminating
Civ V will come with an in game browser which will allow you to access this community (and other similar sites)...from within the game; look for and launch mods...from within the game; mods which can be hosted by Steam or by sites such as this. All of which will be facilitated by the Steamworks API.
The entire civ community will have access to mods, not just those of use who frequent sites such as CFC. I would think that this would be really exciting news for the (current and future) modding community. All of which, again, will be facilitated by the Steamworks API.
It sounds like you can't see the value in any of that, but some of us do. Was it something I would have thought to include? Nope. But I'm glad they did.