I’ve seen a lot of recommends for Immich on here, so I have an idea what the answer here is going to be, but I’m looking for some comparisons between it and Photoprism I’m currently using Synology Photos, and I think my biggest issue is it’s lack of metadata management. I’ve gotten around that with MetaImage and NeoFinder. I’m considering moving to something not tied to the Synology environment.
I think I have a very comparable workflow to yours, I have a master repository of RAW+JPEG on a NAS which I index and curate from Digikam, and I export smaller/de-exified photos into topical folders for sharing with members (generally over nextcloud).