Take a look at something like rclone and it immediately becomes clear that the photo app vendors you listed have no interest in allowing their users to easily access their data programmatically from their services in any meaningful way.

Example: https://rclone.org/googlephotos/#limitations

Glaring example:

> The current google API does not allow photos to be downloaded at original resolution. This is very important if you are, for example, relying on "Google Photos" as a backup of your photos. You will not be able to use rclone to redownload original images. You could use 'google takeout' to recover the original photos as a last resort

iPhoto used to do this. The Mac photos app that has replaced it since is nowhere near as good.

In fact I would go so far as to say my personal photo management never really recovered from the transition.

(and semantically index/search, face recognition... what else does AI get us these days?)