What I'm looking for mostly is search. Like, really good search. Object recognition, all the metadata, etc.

I want to be able to find all the pictures that have a banana in it that I've shot in 2021 with my Canon EOS 5d Mark II, and I want to find them in 5 seconds, typing a single query.

Google Photos used to be good for that, but it isn't anymore. Object recognition got worse and worse as the woke overlords restrict everything and most queries return zero results now.