There is no doubt that Lightroom is a nice product and does a good job as in a photographer's workflow. But I think one can accomplish approximately the same workflow in CS2 or CS3 which I've been doing with large batches of photos and at a rate of 3 or 4 hundrend photos processed in as little as 1/2 hour. I use the workflow that I outline here:
Its even easier in CS3 since its RAW converter has all the same sliders as LR does. So if one has Photoshop already, then I'm not sure Lightroom is really needed.
I also have a problem with Lightroom's color choices for the interface. No matter how I try to change them, I never get something that I can really see compfortably. I have trouble with dark letters on a darker background.
In any event, I think one ultimately chooses the product that they like best. But what I'm seeing among many photographers is 20 different products being used in their work flow. Its a never ending spiral. You get one product to do X, another do do Y, and pretty soon you have an incredible investiment. So I've tried to narrow down the basic workflow tools to as few as possible. Now that CS3 is out, for example, I no longer need Breezebrowser or Downloader Pro since the Bridge in CS3 is now adequate for all these needs.