RAM is capped at about 3 GB. I've seen it use a little less than 3 cores at the most, for Final Cut Pro. Motion, I haven't done that much testing with. Color, either, but I think they can both use more than Final Cut can.
Compressor can use as many cores as you have, and I regularly use all 8 of mine to shorten encoding times.