Jaw dropping stuff indeed!

To think that this sort of thing will be available to us lesser mortals is amazing. It does of course beg the question of the oportunities for fraud that it will give to all and sundry.

Getting back to my oriiginal question concerning Lightroom, I suppose CS4 and Lightroom 2 will still complement each other?

James - Anything that Adobe does leans more and more toward an integrated platform. I've met up with the development team before and it's clear that was a major goal for CS3 - to ensure that all Adobe products are cross-compatible to the highest of standards. 

Adobe has updated this page with some additional info:

http://www.adobe.com/products/photoshop/photoshop/