Photos in Photos.app will get scanned if you have iCloud enabled (required to download the CSAM hash database).
Messages will be scanned for CSAM content if you are a child, then parents will get notified that they received a dickpick.
Messages will be scanned for CSAM content if you are a child, then parents will get notified that they received a dickpick.