Let’s be fair. A off the cuff criminal will not care about CCTV of any type but they will choose to go elsewhere if there is one with no cameras. For those that are career criminals they will case the area first. If they notice a doorbell they usually press the button to check if anyone is home.
If they realise it is a smart one and still want to break in they will smash the doorbell or rip it off the door. An sd card your data is gone.
For me a smart video doorbell is to assist me with who is at the door to assist parcel collection and to open the door remotely if I am either away from home or not close to the front door. Not so much the security side of it. With that none of my external cameras have cloud based storage. Which I have used for many many years.
The only good thing with SD card storage is if they could record without the internet which of course cloud based systems can not cope with.