If you put something on the cloud you are transferring it to someone else's servers, whether Apple, Google, your web hosting account, and so on. Someone else's hardware and responsibility, so yes, a company scanning what you put on their servers is expected and should not be a surprise. Put something on the cloud you do not want to be scanned? Encrypt it.
Quite different from coming into my private space uninvited and looking through my content.
In the world of computer repair, if I fix your computer and find child pornography on it, I must report or I'm an accomplice in the crime. My teacher explained the story when he had a machine brought it in for service. When they booted up the PC, I believe they saw images immediately. His boss said to stop work immediately and call the police.
Same thing would apply to any cloud service holding onto these images and videos. Whether public or private, they would be aiding the criminal.