I ask myself this question at least once a quarter.
I shoot only in RAW except for long timelapses.
Lightroom - besides hating the subscription, I really didn't like the interface
CaptureOne - I tried the demo, but will admit I didn't put a lot into it due to time constraints. It is expensive to buy, but a lot of people love it. It is more similar to Aperture than most if not all. Tethered shooting is strong (so is LR). It didn't offer a good cloud sync option when I tried it, but I haven't looked lately.
On1 Photo Raw - I have the 2017 edition. 2018 is supposed to be much faster, and speed was my biggest complaint here. It took too long to switch from photo to another, or from browse to develop. I am currently considering giving 2018 a go. They have some nice cloud sync tools now available, also.
DXO - I forget what they call their DAM. I loaded it up, but just wasn't wowed by the Demo. Try it yourself, but it felt - more like an engineering tool than an artist tool, and I do a lot of work as an engineer (not in this field).
Apple Photos - light on features, but faster than anything on this list. Browsing and culling is just lightning fast (2014 MBPRo, 2009 Mac Pro, daughter's 2008 MBPro, it is just fast). The addition of extensions was nice recently, but it misses out on some options that the $1 plugin had (Portrait Pro, for example). This is my current solution (with extensions).
Aftershot - I tried the Aftershot 2 demo developed out of the former Bibble software. It wasn't terrible, but it didn't seem any better than Apple Photos while costing more.
Darktable - Think of this as Open source Lightroom. On the plus side, it is open source. It costs nothing unless you choose to donate, and runs on PC/Mac/Linux without a fuss. On the downside, like many open source solutions, the UI is unintuitive at best, and hostile at worst. I also had some serious trouble around "export to web" functionality. Its been a couple of years, but I remember being grateful I hadn't erased the card from the camera. That is not the sort of bug I am quick to forgive.
There are some other open source choices out there, but I didn't get around to them.
On the Horizon.
Luminar - I love the Luminar photo processor. Supposedly they are going to introduce a DAM "soon." There are hints that it will be here by end of Summer, and some indications that it could drop even earlier. As an additional win, there will be support for Loupdeck. No clear statement on other hardware controllers. This is the one I am hoping to be my next choice. I like their "develop" module (with LAYERS!), but need a way to organize photos.
Affinity - They made Affinity Photos, which is so easy to love you'd have to be paid by Adobe to hate it. Now, they miss deadlines on software, but they are working on a DAM somewhere. If it is as good as Designer and Photos, it will probably be tough competition when it comes out.
My vision for 2019 is hopefully Luminar releases a decent DAM, where I put all my photos and just Apple Photos Sync the ones I like the most. If they haven't at least shown me a ray of hope in the next 6 weeks, I will have to consider replacing Luminar with On1 in my vision.
Failing THAT, I may give Capture 1 Pro another shot.