Personally, I’m just went back to using Aperture, because I love it’s features and I was very dissatisfied with Lightroom. Of course, it’s a dead product. But I’d love to see Affinity tackle this, because I’ve been very impressed with Affinity Designer so far.
The things I love from Aperture are the ability to select multiple images and easily compare them quickly to sort through multiple shots. Also, the loop tool is great for inspecting photos for detail.