Is an in-depth investigation like that realistic over a citizen submitted video of a minor traffic violation? No, of course not.
But the other side of this is that if you had more automation in place and could see the data in aggregate, you could get a much better picture of where the problem spots are (for active enforcement or infrastructure improvements) and also potentially identify problem vehicles making the same errors day after day in the same spot (and then either go after them or put them on some kind of watch-out-for list).
They're pretty controversial, but it's nothing new.
I suspect that the bigger issue might be that this type of footage supplied by citizens might not be considered verifiable (it's pretty easy to doctor videos/images these days). Video and images coming from devices that the police/government have vetted would be considered more likely to be authentic. Of course we know a bad actor (or a vendor working on commission!!) could still probably tamper with these...
My neighbor('s wife) got one of those red light tickets and they mailed the picture to him (as registered owner) asking him to identify the driver so they could send them a ticket. I told him to just ignore it since it obviously wasn't him in the picture and he wasn't required to do the police work to track down the driver for them.
On a side note...I was talking to a buddy about this and we were theorizing that they couldn't even compel him to give the name of the driver due to spousal privilege, dunno?
In general though, "don't talk to them" is broadly the best (and really, the only good) advice when dealing with the police.
Ah the old, "Guilty till you prove you're innocent by ratting out someone else".
After a few days you get a letter in the mail with the photo they took of you and information about the fine to be paid.
Remember that our entire legal system was founded on the belief that you are innocent until proven guilty. Not "we think it was probably you" or "statistically it was probably you," but proven. So if my vehicle went through a red light that doesn't qualify as proof that I ran a red light. It qualifies as proof that something a computer thinks was probably my car was in an intersection at a particular moment in time. The state still has to prove I did it to ticket me (in reasonable states, anyway).
Because it's the truth. A driver receives a citation, not a vehicle. And a vehicle owner is under no legal obligation to say who was driving a given car at a given time. So based on those two facts alone, I don't see how you think the police can just drop citations in the mail based on a screenshot or a video clip.