I have spent an inordinate amount of time messing around with Adobe Bridge and demos of Aperture (2 & 3) and previous versions of Adobe Lightroom all with the goal of finding a way to manage my ever-growing library of photos. Nothing really stood out to me and I had a hard time figuring out how I might integrate something into a reasonable workflow.
Until I started using the beta of Adobe Lightroom 3 that is. And with the recent release and the additional functionality that sneaked in between the final beta and the golden master, I think I have found the tool for me.
I may do some posts on specific workflow-related topics, but for a pretty good enumeration of the new features, I'm going to send you to the folks at Ars Technica who I quite like for their detailed reviews.