I also like LR2, convenient workflow and so on. IMO it is ok for D3 files but I think not really great.I quite like Lightroom 2, and LR3 is meant to be significantly better, so I think the likelihood that I stay with it is quite high. LR2 already gives really good results with the D3.
I am not looking for the absolute highest per-pixel and so on quality, just something very good. I am unwilling to spend lots of money and effort getting the last pixel a little sharper, or to improve the colour a little bit (and I have never seen a comparison which was night and day), and thus I never made the step to Capture One, like so many have. I just plod along with my great cameras and decent software, and focus on the images.
C1 light (or however its called ) one got even for free when buying a sundisk card. Its not so mucj money involved.
Not only for Nikon files but also for M8/M9 files it delievers more detail IMO.