I know a lot of people will laugh at this but Photos with its current extension support really isn't that bad. Particularly if you support projects like Affinity and Pixelmator. Having things like liquify tools and lense correction inside Photos without having to leave to do it is finally showing *why* Apple went down what seemed like a crazy path. I've been using Lightroom for years since apple dropped Aperture.. But now I just use LR for individual shoots where i know I'm going to be doing a lot of photo manipulation and keep my main family library in icloud photo library. (I export projects from LR back into Photos when needed.) Lightroom's photo syncing is all a bit "one main machine focused" and fiddly if you use a lot of different cameras and idevices. (you can set a folder to autosync to the Adobe CC but its slow and .. not ideal.. Never mind the fact that Adobe CC doesn't have any sort of decent or 2 factor security, so storing all your photos there seems a bit.. weird. Adobe don't want you do sync your entire library.. But I dont want to be doing wired photo syncs in this day and age outside of offloading from my SLR) Apples workflow between iPad+Photos, if you have a good suite of extensions in both.. IMO.. Is actually more pleasant than the equivalent with LR.
I do really like LR though, its just overkill much of the time.
I agree, for me I am happy with Apple Photos especially since I have 4 Apple devices. I have almost gotten to a point where all of my media/data is on all my platforms automatically...really the only thing that hasn't gotten there yet is video media. (It's great, when I get a new iPhone, iPad, or even Mac I don't really have to even worry about transferring data, music with iTunes Match shows up, photos in cloud, they finally added iBooks to the cloud, documents are also in the cloud. Really the only stuff I have to worry about is my really big pc repair tools and images along with my movies. The future is here. (Obviously Applications but that a different story, depending on the app they may be in the App Store)
Back to photos, my wife the one hanging on to aperture and I've been telling her she's going to have to make a change soon lol.