Sounds like CCCP has advanced some since I last used it. I have at various times over the last 10-15 years tried K-Lite, and CCCP, I have seen a lot of arguments for/against one over the other. The last one I had installed was CCCP which must have updated its default exception list for FFDShow since then -
But really the best set up is not to use a codec pack at all.
Please bear with me and dont chew my head off - Video and audio codecs are complicated layers of filters. On windows, windows media player is the biggest enabler and sets you up to interpret/play a lot of them. The latest updates to WMP include a fair few more than it used to.
VLC media player will play pretty much everything else http://www.videolan.org/
If you need OGG, Theora, FLAC - DirectShow filters is a good addition to the above (and starting to incorporate HTML5 support) http://www.xiph.org/dshow/
The only time I needed something from a codec pack was with some un-usual AVI format vids from an older digital camera, no longer needed so lifes sweeter without a codec pack over-complicating your system setup.
I have seen others needing them for videos they have had on their hard drive, origin unknown but they looked dodgy to me.
Or the need to play apple proprietary content they have previously bought by online methods without having the multi-layered services apple installs on your machine complete with the awful quicktime, and having all their file associations taken over by apple software.
Lastly a couple of packs include versions of Media Player Classic, if you can get the original its good (though not as good as VLC IMHO), but I know of at least one of them that installs spyware with the MPC option ( wish I could remember which it was
).
Edit: The other use I had for codec packs was to expand the capabilities of WinAmp, personally though I think in recent years it has become bloated and besides the highly configureable interface no longer holds enough of an attraction to warrant installing yet another player.