I quite like the system in some Spanish villages. There's a pedestrian crossing with lights and a speed sensor further up the road. If you exceed the speed limit entering the village, the lights go to red and hold you up. Good for road safety (kids & locals), bad for those who blast through, annoying if they're triggering the system behind you though :-)