Sounds similar to my needs. My solution was a self hosted instance of own cloud on a raspberry pi 4 (nextcloud was good but too too many bells and whistles, and was unstable on my system). The owncloud android app automatically transfers my photos and videos, which are then automatically downloaded to my main PC. Important: This is not a backup solution, if I delete a photo from one instance, it will be be deleted on all instances. This system had physical redundancy, as all photos are on at least 2 separate devices at a time.