[modriano]

I'm a crime researcher in Chicago and I work mainly on aggravated battery (shooting) and homicide cases. There have been many homicide and shooting investigations that have been substantially aided by Ring footage (always received with the (often enthusiastic) consent of the homeowner). But it typically takes at least 3 years before homicide cases are tried in court, and no responsible law enforcement agency would release information that could impede cases, so it will be a while before any agency does this kind of analysis and decides to publish it (very unlikely without being incentivized by a consent decree or something). A lot of people (read: relatively well-off (white) people who live in safe neighborhoods) are pretty irrational about cameras and law enforcement in general, but the people who live in the neighborhoods where homicides and shootings happen generally hate living with the constant possibility of their loved ones being accidentally shot in a spontaneous shooting, they want these threats removed from their community, and it's much easier and safer to provide footage rather than testify as a witness over many court dates 4+ years later.

TLDR: Yeah, there are many investigations that are only cleared because of CCTV footage, including Ring footage. No, that data isn't public.