I recently upgraded Affinity Photo 1 to the full suite v2 but don't have any experience on using it for photography work (I use it more for layer work when putting thumbnails together for Youtube videos mainly) but it's clearly a very capable app. More akin to Photoshop than Lightroom however. On my machine here, I have LR, PS, Affinity 2 and On1 RAW 2023.5. Perhaps because I'm used to it I do 90%+ in On1. It lags behind PS in terms of the fancy AI remove stuff, and On1 is VERY slow with 40MP+ RAWs (especially the ones I've put through DxO PureRAW 4, which generally more than doubles the size of the DNG files). But it is mostly now very stable and I'm still way quicker using it than LR/PS for my photos. I daresay any of the options could work well.
DxO PureRAW is a great app btw. It's surprising just how much better fine detail looks when processed through it over directly into On1 or LR. However, you do have to make sure that On1/LR doesn't do further processing of the file by default, as it can then look a bit over-sharpened/weird.