lightroom certainly aint trying to compete with photoshop they have very different purposes...personally i dont like either! i find photoshop far superior.
RAW + Aperture + Photoshop is my method of choice.
IMO Aperture is much more intuitive that Lightroom, and the number of useful plugins available is great, my favourite being Export Version to FTP.
Neither are competition for Photoshop though, both packages have to be used in conjunction with it to get the best out of your photos.
I think the best thing to do is try the demo of both LR and Apeture and see which one you get on with best.
I have both trail version at the moment