Take a look at this topic:
viewtopic.php?f=4&t=20908The vast library of mods is what really extends CC's life (for the people like me who don't make them). Look around the Mod Releases and Scene Releases forums, download some stuff, mess around with them. Instructions on how to install mods are stickied in those forums as well.
Strategies will vary a lot from person to person. I usually enjoy one-man army style battles, so I either play that type of mission or play skirmish defense and load up a single actor with heavy weapons to defend it. Like I said above, experimenting a lot is key until you find some favorite things to do.