Piwigo does have a plugin for video upload and playback, and it looks like Live Photos are WIP or at least available through the website, not the app. There are some other neat plugins too like map/geotag support.

The app’s upload functionality can work well for backups too; it isn’t automatic, but it does support batch/folder uploads and remembering which photos you’ve already uploaded.

I think coastal New England has a lot of potential, specifically Portland Maine, Portsmouth NH, and Boston.

I lived in Portland for four years: its downtown is very walkable/bike-able, they have decent transit options (buses, Amtrak, airport), and seem to care about growth towards people/pedestrian-friendly designs. They’ve been building up their bike lanes, running a bike sharing program in the non-winter months, and are starting to construct denser housing. If I had to settle in the U.S. somewhere, I would personally choose here.

Portsmouth has a smaller downtown, but its also very welcoming to pedestrians. I’m confident they’ll continue in the right direction too.

Boston’s much larger than either of these, though that comes with strong public transit through bus, train, etc. A better choice if you like big cities.