Hey Tom!
Thought I'd chime in with my .02 cents worth of opinion here
I'm a 38-year-old photo enthusiast that started working with cameras sometime in the early 90's. I loved film, it was beautiful and had nice qualities to it that I admired. But after having all of my film cameras stolen (TWICE!), I finally stepped into the digital world, and needed a good way to process digital images. That's when I got my first copy of Photoshop. I had an old versions, just the basics, but I learned what I needed to. I used the bare minimum of Photoshop for a couple years until I decided I wanted to do MORE, and decided to teach myself how to use Photoshop *properly*. It seemed VERY intimidating at first since there were so many buttons and options and things to do. But there were plenty of tutorials online, and MANY books, one of which is quite useful, more on that in a moment.
The reason I tell you this, is that I have used Adobe Lightroom. I have used (and own) Aperture. I also own a full Adobe CS3 suite of software. Of all the digital processing tools I have used, I find that for the most accuracy and the best ability to control *all* of the fine details / burning / dodging (repairing / fixing if that needs to be done), that Photoshop gives me the greatest sense of satisfaction when an image is done. Aperture and Lightroom are both GREAT pieces of software, but in the end, I find that for *me*, Photoshop is much more flexible and offers more possibilities, even if it means you have to learn something new.
I would personally recommend that you pick up at least Photoshop (in whatever version you need, CS3 does just fine even with the most current RAW files). Older versions of Photoshop often cost HUNDREDS less than the most current versions. And, once you choose (and purchase) your desired version of Photoshop, then go get a new or used copy of "
Photoshop CS3: Classroom in a Book" (or CS4, CS5, etc). The Classroom in a Book series are really well written, easy to understand guides to learning the features of Photoshop, and give you the tools you need to manually process your images.
If you buy the actual book, it comes with a CD that you use in conjunction with it to learn each lesson. The book has photo's showing which tools to use, and detailed descriptions to help make the process pretty simple. After I took the class for two semesters, my professor asked me to assist her in teach the course, because besides what I had taught myself, the book helped fill in a lot of gaps and made it fun / simple to do.
The nice part about Photoshop is, it's not *just* for processing images like Aperture and Lightroom. It can be used as a very powerful
creative tool if you should choose to do more with your images than *just* process them.
Here are a couple examples of photos I took and processed , all self taught with these books and Photoshop CS3. Each require some minor little fix or adjustment such as burning / dodging where it was needed, without changing the overall original image, just minor repairs. Or in the case of my yellow Beetle there, I had it washed and waxed, then on my way to the photoshoot, I drove through a puddle that was unavoidable and splashed dirt on the side of my car. So I removed the dirt in Photoshop.
And yes, the colors on the sunset are natural! It was a breathtaking sunset and I have an even larger panoramic version of it as well.
Had to remove some small bits of dirt, and torn spider web off the flower, and touched up the shadows on the petals with a little burning to really make them pop.
The nice part about Photoshop is the ability to retouch images where you need to remove blemishes quickly and precisely without effecting the rest of the image.
I had to remove a number of small blemishes from my niece's face and the Photoshop 'Patch' tool is pretty awesome. No airbrushing was done, just removed the blemishes, color corrected, and removed a couple of stray eyebrow hairs that she asked me to remove, as well as tweaked a few shadows to soften them up a little around the face / nose.
When you want to start doing more fun & creative things like Photo-manipulation, layering, etc, Photoshop is definitely better. Here are a couple examples of things I did with Photoshop for fun.
(full sized version here :
http://farm4.staticflickr.com/3176/5735819397_c8010650b8_o.jpg)
On this "Got Faith?" piece, I had to do a lot of work on my friend Rose's face. Her husband had been very abusive, and she had bruises all over her face. She also suffered from a malady that caused her to have the use of only one eye, the other eye does not open. And while she was feeling particularly depressed, I took some photos of her, touched them up, printed them out, hand-cut the matte-board, and provided her with a framed copy, so she would know that she was still loved and that she was STILL a beautiful woman. Photoshop provided me with some quick ways to quickly give her another eye and fix all that needed fixing.
One last image... just another one of those "I have too much time on my hands, lets have fun with Photoshop" moments.
(larger version here
http://farm3.staticflickr.com/2368/5735819427_b389bacb29_o.jpg)
Anyway, just some examples. Lightroom and Aperture are both great. They will both "process" an image, and help you tweak them a bit. But then they are done.
If all you want is quick way to process a file and get done with it, those two programs will get the job done.
If you want a program that will process your images, AND give you a heap more potential in what it can do, spend the $ on Photoshop and then take some time every day (or twice a week) to learn how to use it and you'll be happy that you did!
Just my opinion though