The cameras can read the license numbers of cars going up and down my dead end street, and have a NTP synced time stamp on them. So I have reported license plate numbers to the police a few times when various neighborhood issues have come up.
But no, I don't think it will magically arrest someone breaking into my house. But they are still pretty useful. Did someone leave a package on my front door? Is my kids friend's parent here for pickup/drop off? Did the garbage truck get here yet? WTF is that loud truck noise out front? Is that knock at the door someone with a clip board? Or someone trying to get me to believe in their god?
One thing it does help, is that at least in my area it's common for a thief to knock to see if anyone is home, then break down that door or force a rear door to enter the house is nobody answers. So being able to see and even respond to the knocker might well prevent a breakin, even if you aren't physically there.
But at least if you know something is happening in real-time, motion triggers being the most important, there is at least some chance to intervene or call the police depending on the circumstances. Even if you can't stop them, speed is key, and if they are on foot they could be caught in the area afterwards with vague id such as clothing only. Capturing a license plate is probably optimal though, if they aren't on foot. Cameras are very good these days - HD and higher 30/60fps video - not the pixelated/blocky/useless recordings of 10 years ago.
Also good to know ahead of time if there is anyone snooping around looking for easy targets (as small-time burglars do). Some systems do also have monitoring services.
Otherwise yeah, cameras are at best a deterrent and source of evidence, nothing more as a passive device. Best security system I've ever had was a German Shepherd. Fully autonomous deterrent + active response if necessary :)
I'm probably not a good example, I live in a small apartment, don't have any valuables besides passports and loose change. I just don't see much of a point for having cameras. Instead I focus on deterring casual burglars by using semi-intelligent timer-based lights plus a simple radio tuned to a station with lots of talking when we're away from home. Perhaps a security cam has a deterring aspect, but not sure of the legality of it in Germany where I live, and I guess a dummy camera would achieve a similar effect as a real one?
What am I missing? :)