I share your pain.
The DJI Fly app syncs to my phone, which then syncs to Google Photos and my own cloud (Nextcloud). Depending on the need, I can quickly search Google Photos with it’s object recognition built-in, if I just want a JPG - but this is lower resolution, due to Google’s compression. If I want the full res JPG or RAW, then I will either I have to search/browse my own cloud. I obviously still have to copy off the SD card to my cloud manually.
I also have Adobe Bridge to search, manage and view all content. It can default to a specific filepath, and you create custom keywords and sub-keywords to structure and retrieve your data.