The Cameo will cut pop-up cards. If you browse the Silhouette Design Store (used to be called Silhouette Online Store ) you can see the kinds of cut files they have available for immediate download. http://www.silhouettedesignstore.com/
If you upgrade from the basic software to the Designer software, you can cut SVG files, like designs from one of my favorites- SVGCuts.com (shop around for the software-there are often deals to get it for a good price)
Silhouette School shows how to make a basic pop up card then you can add whatever you want to it. It's one of the best places online to learn how to do things with your Cameo!