I’m not saying this is the right way to handle things, but it might give you some ideas. My approach is:
– Use the file system – this means I’m not locked into a cloud storage provider, editor/manager or operating system
– Use XnView to import files into a directory structure based on EXIF (I use YYYY/MM but it’s pretty flexible)
– I use Mega for cloud storage, mostly because I already had it before switching to Mac, but also because I still need to sync to Windows machines and iCloud on Windows is terrible
– Photos I take on my iPhone are automatically uploaded to a folder in Mega and synced to my MBP. I then use XnView to move these into my YYYY/MM folder structure
If I want to edit on both my MBP and iPad, I use syncthing to sync a folder (it works well, with some limitations – https://support.gentlemencoders.com/forums/topic/sharing-edits-between-mac-and-ios/).