As a very, very sad Aperture fan…I understand where you are
I used to keep EVERYTHING in Aperture: DSLR pics, iPhone snaps, and videos.
After Aperture was kicked to the curb I looked into Lightroom, but ultimately decided against being tethered to Adobe for the rest of my life (my PS is CS5, and it's still way more than I'll ever need, and I already paid for it once).
So I decided to bifurcate my workflow: embrace Photos for everything iPhone: photos and videos. And I decided on Capture One Pro for all my DSLR stuff.
Capture One is the best RAW converter out there, and (if you get over the learning curve and UI curve, which aren't drastic…but are a little different) you'll be using what most pros use, and getting some great images. Sure, Lightroom has some different features (some for the better, some not), but for me the subscription model was the real deal-breaker.
The only downside (imo) of Capture One is that its Catalog/database is absolutely terrible. If you're coming from Aperture you might want to break things after dealing with it. But Aperture was the gold-standard of DAM, and Lightroom isn't much better with large libraries than Capture One, so…unfortunately I would say you're probably not going to love any DAM as much as Aperture. Hopefully Capture One addresses this in their next major update, because if they did they would gain a lot more marketshare.
Affinity and Photoshop are for pretty heavy duty photo manipulation and retouching, and even image creation. I use Photoshop quite often, but rarely for my photos. If you are doing "photography" Affinity might be overkill for you, even though it's not quite as deep as PS.
As others have mentioned you should really check out Luminar, by Macphun. It runs stand-alone AND as a Photos extension. It's by far the best "mid level" photo editor I've ever seen. It has some really great "one click" filters and things (think Instagram filters, but way way better quality). But it also has layers and masks and some decent retouching tools (I'd say almost as good as Aperture's), so you can deal with 99% of the stuff you need with Luminar + Photos (as the library).
This is not a scientific chart, but in my mind this is the "ease of use" list:
Photos
Luminar
Lightroom
Capture One
Affinity
Photoshop