Content query web part is fine - as far as it goes

Make sure that you're using the thing to the max
http://www.datasprings.com/Resources/ArticlesInformation/AboutSharePointContentQueryWebPart/tabid/835/language/en-US/Default.aspx


So Microsoft has a good looking paper - to tweak the query to do someone pretty cool stuff
http://msdn.microsoft.com/en-us/library/aa981241.aspx
but it looks a bit too easy to make a mistake - a bit headache inducing

But hey codeplex comes to the rescue -
http://www.codeplex.com/ECQWP


If that looks a bit too much like rare meat try -

http://www.heathersolomon.com/blog/articles/customitemstyle.aspx