I've looked at Photos, and whilst there are some nice things, it's no substitute for Aperture.
So - I know Lightroom quite well, and I've been using it this year instead of Aperture. . . . but I can't love it - especially the 'clone' tool is rubbish, and I use it quite a lot for removing unwanted elements in images. I'm not really happy with the cataloguing either.
Worth mentioning that I've always used Aperture with 'referenced' files rather than 'managed'
I've used Capture One in the past, but hadn't realised how much they had upgraded the DAM functionality.
What do you think?