I had shifted to Affinity photo from Photoshop few years ago. I need to use it once in a while so Affinity photo does the job for me. It has its own quirks but I can live with them. There is still no real alternative for Lightroom unfortunately for bulk RAW photo processing.
There was talk of them working on a DAM solution a few years ago, sadly this never materialized. I would love to be able to move on from Adobe completely, but I still haven’t find the right replacement for Lightroom..
Last time I tried to completely switch to Capture One, there were major features missing. I currently use both because there are things that Capture One does a lot better than Lightroom (eg. skin tones, tethered shooting)
The biggest one for me is the fact that you can't manually remove chromatic aberration. If your lens is not in their database with a profile, you can't do it at all. The database is also very small; if you are using anything old or with no electronic, it's likely not gonna be there.