I’m not a keen fan of Lightroom for productive imaging workflow but do think its a great way to manage collections of images (search, re purposing etc). Its ideal for small to medium sized businesses who don’t have custom programmed image databases but need some of that functionality.
Its also my preferred platform for auto importing when shooting tethered when its important for art directors to see the shot asap after the shutter is released (though via the canon capture software rather than the built in tethered options). I have been using the Beta of 3 for a while, the release code is on order and I will let you know if there are any changes.
More details from Adobe here: http://www.adobe.com/uk/products/photoshoplightroom/?promoid=DTEWE