I use a Mac w/ Aperture, and have for some time now (since it came out) - I'm happy with it. I use Photoshop to edit, but most of the time, I don't edit, unless there is a picture that I just "have to have," and it didn't come out of the camera quite right. I've found that for the sunrise/sunset problem, often adjusting the exposure level in the camera (prior to taking the picture(s)) solves the problem.
I do have a couple of clients who use Lightroom, and have been tempted to switch, but I'm not sure that it is worth the trouble/expense.
I use Time Machine to backup, have a vault in Aperture, and use a couple other methods as well, including keeping an offsite copy of my pictures and data in a secure location.