tango As for your Apple dilemma you could get a Proton account and use Proton drive to store everything. Might be a bit time consuming (like all privacy efforts are) but changing over is simple.
At the moment you can't get more than 500 GB of storage in Proton Drive (as far as I can see), maybe that is not enough for this user. Also, Proton Drive is just a pure storage solution, not a media management software.
I think Piwigo seems very promising, especially if you host it yourself on a TrueNAS system (they have direct support for that) https://piwigo.org/
Then you have a very powerful photo manager. Please note that I have not tried this my self.