Talking of awesome KDE apps, digiKam 8.7.0 has just been released!
KDE’s full-featured image and photo managing software enhances its face detection and recognition feature, improves support for GPU actions, and updates its RAW decoder, G’MIC plugin, and more.
https://www.digikam.org/news/2025-06-30-8.7.0/_release/_announcement/
This looks like the specific kind of tool I’ve been searching for for a long time. Looking forward to trying it out