San Francisco has a few of these, but they're keyed to bicycle speeds (13 mph or so).
On the other hand, there was an article here about something Portugal did about speeding. Basically, they would put a useless stoplight in the middle of nowhere. Normally it's green all the time, since it's not actually an intersection. If you approach it while speeding, however, it turns red.