If there's an actual arrest and trial, the Supreme Court case of Brady v. Maryland (1963) requires that the state hand over any exculpatory evidence [1]. The state has to go out of its way to hand over evidence -- even if the defendant doesn't know it exists.
[1] "Exculpatory" = "might show that you are innocent." There's a long line of cases that define how broad that definition is.
* I am not your lawyer. Go get a criminal defense lawyer.
What you're talking about is evidence in a trial, which can still remain sealed, and has nothing to do with the public being able to view the footage.
What if while arriving on scene to a burglary there is body camera footage from an officer that appears to show someone running off and away from the scene carrying [whatever was stolen] and from that footage one could possibly conclude that the personal doesn't look like the person the police decided to accuse and prosecute. This could be exculpatory evidence and help clear you of the charges. (Obviously the prosecutor is suppose to let the defendent and court know of any known exculpatory evidence, but what if the police choose to withhold it from the prosecutor/court or don't think anything of the footage? )
This part seems curious to me. Isn't that exactly when a person "who can be seen or heard in it, along with their personal representatives" (e.g. accused person and lawyer) would need access to such footage? Perhaps there is some nuance here about what constitutes an active investigation?