I used the trial version at home before and my views on the software:
It is very similiar to Adobe Lightroom and Apple Aperture but offers slightly more image processing features (go look up at their website for more details). The downside is it uses up a lot of system resources and user interface is not to my liking. It might take some time to go around using it effectively. Its main feature which I use the most is the specific lens distortion correction and perspective correction for the fisheye lens. Other than that, I feel when compared in terms of advanced post production, e.g. selective masking, layering and other effects, the Adobe Photoshop CS3 is much more versatile and flexible software. However, if you seek a one software that does it all e.g. basic image processing with a bit more advanced features and workflow management, you may want to give the DxO Optics another hard look.
Hope that helps. Cheers!