Lightroom for simple cataloging and general developing. Paint Shop Pro for creative work. Noise Ninja for, well, you can guess.
Remember though, it's not just the tools. You can create equally compelling pics with Gimp. It's all on how you compose. More time shooting, less time editing.