Final Cut Studio 2 includes Final Cut Pro 6, Motion 3, Soundtrack Pro 2, Color, Compressor 3, and DVD Studio Pro 4.

There's also a marketing video talking about how to use FCP6 with the Red camera, and here's the NAB reel highlighting content edited by FCP.

I wish I had time to sift through all the details today, but I have a lot of work to do for class today, using, what do you know, FCP.