iCloud obviously syncs other data, not just photos. I would rather not have things backed up on hardware, having learnt the hard way. I use various cloud-based services to back up and sync data and files.
I have never used iPhoto nor Aperture for any serious professional application, as Photoshop is the de facto solution, but I believe that 'Photos' is the merged offering. These days I would recommend 500PX's Awesome plus Adobe subscription for a good deal on editing and showcasing.