It doesn't work for every app. Not sure if it's opt-in or opt-out.

Which apps doesn’t it work with that you think it should?

I am looking through my apps and most of them are clients for server side functionality or productivity apps that use iCloud Drive, OneDrive or Google Drive.

Google Photos would take care of videos and photos and Contacts and calendars use standard syncing protocols.