The problem with non-cloud cameras, I think, is that burglars can, and likely will steal them. This kind of defeats the purpose of a security system.
They are not a common vector for burgling.
Push notifications while I am away or being able to review people casing the place or such are bonuses.