I have never used Lightroom but many of the best photogs do! There workflow is most often Lightroom > CS3 > Final Image.
I use CS3 only and can tell you that it is a billion times better than the Canon interface to do raw editing and would have to assume that Lightroom is better than CS3 or why would they use it.