A May, 2007 court ruling shut down Charlotte, NC's red light and speeding cameras because the proceeds from the tickets did not go to the schools as promised. Looks like they are not coming back any time soon. Just this past week the Charlotte TV stations ran a story about the cameras nationwide.
BTW, a while back there was a man from Chicago who was sent a ticket via a camera in Raleigh, NC, and he has proof that he was in Florida at the time. (Turns out the guilty vehicle was a rental.) There was a legal case in Canada over one of the companies that provides municipalities with the camera service.