I dumped Google photos for self hosted immich and it's been great. Not sure if it has the ability to connect to photo frames but if you already self host anything else it's not too much work to setup.
This is one of the few things I can get behind with machine learning. Locally run, doesn't "phone home", just analyzes faces and categorizes them. That's it.
It's really not that heavy. I have Immich - and several other services - running on a 4-core VM with 16GB RAM, running on 7th gen Intel hardware alongside another 4c/16GB VM and several LXC containers. It does the job just fine with more than enough overhead.
Self hosted doesn't necessarily mean hosted at home. Some of my stuff is for example hosted in a French datacenter for redundancy. At one point it was my only server space since hosting at home wasn't feasible at that time.