Right now, my Android-centric workflow uses Google Photos for collection, editing and sharing of images (I've long ago given up on its content-sensitive facial recognition features), followed by downloading / offloading and sorting everything into appropriate folders in Google Drive.
The problem is the sheer effort involved in those latter steps! I'm overwhelmed with the quantity of files and having to manually group them into "Event1", "Event2", etc. And Google Photos is SLOW.
Moving back to something NAS-based as described here not only makes great sense, it puts the biggest chunk of my workflow into the local CPU space rather than cloud-based. Less fear of losing stuff.
Of course, one can always use a background utility like Synology Cloud Backup to send the finished collection back into the cloud for extra safekeeping.