I've been trying to find the best way to manage my photo library without using Google Photos.

This is a (long) story of how over the years I've tried several alternatives (the good old Picasa, Monument 2, Synology Photos) to end building an Unraid server and test there a lot of self-hosted alternatives, which I compare to finally select Immich, the one that I think is the best for me.