So here are some answers to your various tests.
Testing version 2.0 of PSE is not a valid test vs. other programs. PSE4 is way better, and is a lower price option for those who can't afford, or don't want full CS2. Makes an inexpensive advanced pixel editing add on for LightRoom or Aperture. Supports standard CS2 plugins. Not Intel native.
CS2 is, in my mind, an absolute must for serious hobbyists or professional photographers. But it is not an "end to end" workflow solution. It has no DAM capabilities.
LightRoom is a good "end to end" workflow solution for those shooting primarily RAW (but it does work with other file formats). Some, or all of your images may have to be "roundtripped" to CS2 or PSE for further editing. DAM capabilities still need some work. Not as full featured as Aperture. Very Modal (have to switch between editing "modes". Not all tools availalble in each mode.
Aperture is another good "end to end" workflow solution, again best for RAW, but works with others. Much deeper program than LightRoom, therefore higher learning curve. But rewarding if you put in the effort. Non-modal, that is most all tools are available no matter what you are doing. Supports dual monitors, has plug in architecture for third party photo sites. Best DAM capabilities. Very flexible. Hardware hungry.
I agree that the tutorials online are a little limited. Are you sure you actually navigated to the tutorials, and not just the "tours"?
Try this page for full tutorials. Frankly, I think they are pretty good.
http://www.apple.com/aperture/resources/tutorial/
If these are not enough to get you going, try this page:
http://www.apple.com/aperture/resources/
And then do a Google on "Aperture Tutorials"
Kendall Gelner, a frequent poster on here, has an excellent tutorial on Aperture Adjustments on his website, the name of which escapes me currently.
--
Only my opinion. It's worth what you paid for it. Your mileage may vary! ;-}
http://www.dougwigton.com/