Aperture is a high end photo program that will help you catalog and sort
large numbers of photos quickly.
I've always found Aperture pretty cumbersome to use, especially since
I shoot in RAW mode, not JPEG, and don't have that many photos to sort
from any given shoot.
If I were a wedding, event or sports photographer where you come
back from a shoot with thousands of images to sort and categorize
quickly, I know it would be of more use to me.
I usually use the Browse function in Photoshop.
Keep in mind Aperture is not really intended as an image editing
tool, it's capabilities are very minimal there.