Hi, Ive been playing the crap out of CC since the Humble Indie Bundle even though its not finished but Ive pretty much run out of things to do in it now, I just wanted to ask, what are the best mods that people would recommend for expanding the original experience or even adding a campaign? Ive looked in the mod folder but its hard to know whats finished and if its any good or not, thanks in advance.

Everything in Mod Releases is a fully functional mod. Look for threads with large pagecounts if you want "good" things, as the threads with a lot of comments usually have good mods in them. However, it's not always a good rubric, so search around.

http://forums.datarealms.com/viewtopic.php?f=61&t=21397
Here's an awesome mod.

There's a thread around here somewhere that was specifically for folks' favorite mods, or some such. I recommend looking for that.

Does it have new scenarios/levels etc?

Give me a link if you can find it please Nocifer, thanks.

Look for weegee's and TLB's missions in the Scene Releases.
Abdul Ahazred has made some quite neat stuff too, with both missions and stuff like vehicles.
And Gotcha! has made a very large mod with bunkers, actors, guns and more named UniTec.
He also made a bunker systems/modules/bits pack named Map Pack 3. Also comes with a metric ton o' scenes. Not missions, though.

Just something from the top of my head.

herbert, advertising your own mod as 'awesome' when it really isn't isn't acceptable in my book.
Learn some etiquette.

I was just kidding, sorry, it just bugs me when people ask questions like that instead of just looking themselves and trying stuff is why.
PS: I know my mod ain't great but it's my first.