Lightroom 3 stands alone for most basic work, RAW can be edited in LR3, red-eye corrected, colour balanced, colour aberrations in the lens corrected, even spots cloned.

And for complex editing, layers, masking, then you can use other editors. It integrates well with Photoshop (of course, they're both Adobe) but also works with other programs.