Since I take lots of photographs, I recommend the following, and YMMV.
Disclaimer: I am not a "professional" photographer, in the sense that I don't get paid to photograph.
I store all my digital files as files. They are not trapped in some tree structure (as Apple Photos does) that you have to be a scripter to unpack.
And I can rename, tag, sort and otherwise deal with the images as good old files, or even stuff them in a database, should that be my fancy.
I get such high quality jpegs from the Nikon gear that I rarely have to process them beyond the Apple Preview app. Anything else goes to GIMP, or to Raw Therapee or Darktable.
For transfers, SD cards or Image Capture. And when asked to help transfer to and from random gear (Apple, Android, Windows) I just buy friends a copy of PhotoSync, which seems to work on everything (except Linux, I guess) but scp and rsync have always worked wonders. And there's always sneakernet.
I really resist proprietary software and storage schema.