I shot the attached image of a moonset over our beach yesterday. As I wanted a long exposure I set the camera (Canon 5D) at the lowest ISO and the lens (24-105) at the minimum aperture (I did not have a neutral density filter and plan to get one). So, not surprisingly I ended up with a lot of sensor dust on the image.
I found that the spot correction tool in LR 3.2 is incredibly slow and seems to get slower the more spot corrections in an image (I had over 50, but that's another story). Furthermore, I found that the corrections often generated artifacts because it is a cloning tool, even though I was careful where I shifted the source circle to.
Anyway I soon got sick of this and removed the remaining dust spots (and some of the artifacts) with the spot healing tool in Photoshop Elements 7. This was much, much quicker and produced a far superior result.
The one advantage of LR, is that the spot removals can be pasted in another image.
But for me, I won't use LR to remove a large number of dust spots in the future.
Cheers