Immich looks particularly good to me.
It is! Been running it for a few years now and I love it.
The local ML and face detection are awesome, and not too resource intensive — i think it took less than a day to go through maybe 20k+ photos and 1k+ videos, and that was on an N100 NUC (16GB).
Works seamlessly across my iPhone, my android, and desktop.
Take numbers with a grain of salt, e.g., this link says a 7200RPM 160GB SATA drive from 2004 is $107, or about $0.67/GB, instead of the $5 claimed in post.