Right now by far Adobe Premiere CS5 has the best support for DSLR's.
In marketing hype yes, in reality...not really. Still very much a PITA to edit and manipulate a timeline with native DSLR (5d2/7d) footage in Premier. There are some bonuses, but they are mainly on Windows machines or those that've upgraded to Cuda enabled nVidia cards on Mac Pros...even then, there are very few "bonuses" to Premier right now with DSLR footage. It's still the same as with FCP...if you transcode your footage, it'll cut like butter..
....and Canon has been incredible issuing plugins for their DSLR footage on Log and Transfer through FCP. Incredibly fast transcoding to Pro Res on ingest. Nothing like the original days of transferring 5d2 footage, when it was in 30.00 fps...and using Shake to conform to 29.97....blah, blah, blah. We've come a long way just with plug-ins on this issue...and Pro Res is as good as it gets IMHO for editing.
I agree though with the points on the rest of the suite. It's going to be interesting to see how it all plays out...and whether or not some of the attributes of Motion (After Effects ideas) will be "baked in" to FCPX...or if Motion will remain a stand-alone app. I'm fine with Color as it sits. It's excellent for what I need it for, and I've never found the need to switch to Davinci. I don't believe Apple is willing to throw that deck of cards in just yet, especially considering the "Foundation" of Color and how much positive there is to build on. As far as Shake and the idea of compositing...I've completely moved to After Effects and not sure what it would take me to make the move back to using Motion...other than for the simplest of titling, et al. I do still have Shake on my Mac Pro...but the last time I used it was, as mentioned, in the days I had to conform my 5d2 footage from 30fps to 29.97. Cool Program, but it's had it's day...After Effects is an Awesome program...and, other than PhotoShop and Audition....my favorite Adobe offering. I'd LOVE to see Apple provide an alternative with merit to AE...Again, competition is good. I can see these possibilities being built in to the new FCPx...at least some of it. We'll see.
As far as authoring...I've used DVDSP, iDVD...but over the past two years, I've come to rely mainly on Toast. I just like it.
I'm a big Logic user as well...and I do look forward to LogicX (or whatever) and the ability to use Logic and FCP together...hopefully, Logic now with Audition!!!!
Jer