I use Aperture to edit and manage photos for personal use and for my profession. I don't sell photos but use them to augment my reports and presentations. I don't need LR. I'll use Aperture for the next year or so till I see how Photos turns out. Might be adequate. If I get the lighting and exposure right when I take the picture I find I don't need much post processing except for cropping.
I'm with you. I rarely used most of the photo editing feature of Aperture. I got it because my photo library was huge, and at the time iPhoto was slowing to a crawl trying to manage it. I heard Aperture was better at handling large libraries, so I gave it a chance.
Honestly, I found the photo management in iPhoto much more suited to my needs, and I missed some of the features of iPhoto. Eventually, those features got ported to Aperture, and the Aperture library could be opened in iPhoto, and vice versa. But it felt a bit unnatural to do iPhoto things in Aperture, and I worried about whether opening the library in one app and then the other might cause me to lose something.
I have high hopes for the Photos app, and for photos in the cloud in iOS and OS X. I think the management of the files will suit my needs, and so will the basic editing features. If there's a feature or effect I want that Photos is missing, then I can buy an app that has that feature or effect. Then I'll be able to access my cloud library of photos from the app, and make a non-destructive change. Or I can access the app's features as a plugin from the Apple Photos app.
I think Apple is smart to provide a way to organize your photos and make them available to you anywhere you have access to the cloud. And they're smart to outsource the specialty image processing functions to others. Not everyone needs to have a filter that re-works your image in the style of Edvard Munch. But those who do, can add that functionality with little fuss or expense.
The real pros can still use Photoshop, of course. I bet Adobe doesn't wait too long before adding the ability for the Apple versions of their software (maybe the Windows versions, too) to read and write to Apple's cloud library.
I'm not considering Lightroom at this time. Their promotional material says your Lightroom photo library is available anywhere (just like Apple's cloud), but I think it won't be as integrated. Adding an image from your library to a text message or an email or a Pages document won't be as easy using Lightroom. Easy integration is important to me.