RAW Power can only access the System Photo Library (Apple restriction). You set that in Photos preferences. For iCloud to work, you need to turn on iCloud Photos inside the Photos app. So, step one is to get Photos on the Mac to see your iCloud Photos library. Once you have done that, RAW Power should work fine. That why I suggest starting Photos and testing the sync there.