Some, at first. Where a camera has training contributions switched on, scOS goes through a learning period while it tunes to that camera — typically two weeks, and again after a significant change to the camera or the property layout. During that time you may get more alerts than usual, or alerts for ordinary activity. Cameras without training contributions don't go through this period.
After that, you should get far fewer false alerts than with motion-based cameras. No system can promise zero.
Most security systems drown you in notifications until you start ignoring them. That defeats the entire purpose. When you get an alert from scOS, it should mean something. Otherwise, what's the point?