The Lightning Conductor Web Part is one of our best sellers as it has a very good UI for end users to configure how to rollup and display their SharePoint information, but also with the ability for developers to apply their own XSL styles and really weave some magic. Brett’s done a good job recording some new screencasts and articles to show you how do get the most from the web part:
Getting started with the Lightning Conductor Web Part
Rolling up lists and libraries with custom columns
Rolling up your content type information
Configuring XSL styles for the LCWP.