It gets backed up to all of these? On iOS I have tried all except Google and they are all finicky. Even iCloud/Photos.app seems to have a brain of its own.

And on the Mac Apple engineers have made sure the photos are not synced in a simple easy folder hierarchy that can be backed up elsewhere.