Absolutely love, love, love Affinity Photo and Designer, both for their own merits and also because they've allowed me to ditch some major chunks of the Adobe subscription model. At the moment, the only thing that's keeping me from cutting ties with them altogether is the fact that Photo doesn't include solutions for a few functions I find myself turning to Lightroom for on a regular basis.
I don't even really need a full on asset manager. I'm okay with using Photos for most of that. What I really need is a way to easily make batch adjustments to RAW images I pull in off my camera. My usual workflow is to pull them into Lightroom, use the previews to flag a few of the images I feel have potential. Then I often make some quick exposure and white balance adjustments that I will simply sync to other images taken under similar conditions using the built-in Lightroom function.