This really could use some clarification on what category these belong to. Most of these projects are open source projects where you can either self-host the tool, or choose from one of many free or paid instances online. If someone lacks the technical skill, hardware, or time to self-host, they should shop around. Often there is an "official" instance by the developers, but that's not always the best option. Sometimes a paid option with more resources is going to be more stable and performant.
Other suggestions are individual companies services, and a couple of these are just applications you install on your device. It would be helpful to readers to clarify.
I use both Nextcloud's Memories app and Immich simultaneously for now, with the same photos. Immich is pointed at a read-only bind-mount of my Nextcloud photos folder on the server side, so they see the same photos. My photos are a mess and I absolutely need the local AI stuff, and right now, neither is perfect, so I have both running and bounce back and forth. If one of them clearly pulls ahead, I'll probably settle on that one in isolation.