Affinity is great for editing but doesn't do the library management stuff that Capture One/Lightroom etc do.

I haven't, but based on the history summarized in this post[0] I'm guessing they will soon force everyone into their subscriptions anyways

[0] https://mg0x7be.github.io/affinity-enshittification-how-canv...