I recently got my hands on an old Synology that I set up with tailscale (not EU but Canada). The photos experience is every bit as user friendly as iCloud or similar. I though a long time about clever setups but concluded that I’m not all that clever and as Voltaire said “perfect is the enemy of good”. This got me off iCloud with little more effort than plugging the thing in