Aperture vs Photoshop
I'm currently making the transition from Lightroom over to Aperture. You are right in that Aperture is more like Lightroom than Photoshop. Its primary use is as a digital library for managing your photos, and videos. Much like iPhoto.
Lightroom and Aperture both have good editing functionality and both have the ability to use plugins for expanding the editing functions.
Both applications also allow non-destructive editing. Meaning you can always go back to the original image no matter what changes you do to the image within the application.
Aperture, like Lightroom, is designed with the photographer in mind. Digital assest management, photo editing, and exporting abilities for printing etc...
It's best to use either (or both) of these alongside Photoshop. I use Photoshop when it comes down to the heavy editing, or when I"m trying to do something more creative with the image outside the abilities of the other two applications.
I'm still learning Aperture so I cannot comment too much on its strengths and weaknesses vs Lightroom. Here is a post by Scott Bourne as to why he uses Aperture over Lightoom.
Hope some of what is here helps.
Using Aperture/Lightroom require a different way of thinking to Photoshop.
Personally I use Lightroom as it is more like the traditional darkroom process. It's also quicker for getting lots of images out the door, which works well with my style of photography (motorsport), the editing functions aren't as deep, but they are pretty much the same as Adobe Camera Raw in Photoshop. Aperture is slightly different, but the same sort of style. Both Lightroom and Aperture have great image management databases which help my workflow a lot.
It is down to personal preference, although at 1/10th of the cost of Photoshop, Aperture is a bit of a bargain, if you can live without the extra editing features.