Well personally I think that in the professional space there is only one image editing programme and that is Photoshop. I don't think that will change any time soon. It is clunky but the cost of the programme is minimal compared to the learning curve to change if you value your time at all.
As far as catalogue programmes, they all have limitations. Lightroom is fine provided that you only have one machine and can afford to have that machine unusable while you do backups. I don't think it does anything well but it does most things to some degree. I have a LR/PS bundle so I already own it but don't use it.
We desperately need a replacement or upgrade to Aperture as a solid database that can run on a server and supports all raw files. Access from any machine, automatic backup overnight, supports all cameras, videos, smart albums etc.