I have never had any issues transferring photos from my Nikon DSLR, however my iMac is a 2020 when they still had room to install a SD card slot. Current 24" models are too narrow to accommodate one. In addition the photo software (Photos app) on the Mac FAR exceeds anything that Microsoft includes in MS Windows. You are just used to one work flow and simply need to learn a new one, not a big deal at all.
If you want to use Canon software then you need to check with Canon to see what they do and do not support. Personally with my Nikon, I simply remove the SD card, put it in the slot, launch the Photos app and import, edit, organize and customize my photos right in the app. Nothing to it, you just haven't learned that yet.