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.
Edit: now that i'm thinking about it, a lot of the streets in the TL, fidi, and soma are pretty well timed for bikes, but for a faster pace, like 20 or so, and maybe 25-30 for the big soma streets like folsom, howard, harrison, bryant.
Normally those red lights are placed around schools and such.
If you're a responsible driver, you're already driving at the speed limit at those sites.
In fact the fastest/cheapest route to prospect heights from lower manhattan is to take the williamsburg bridge to lee ave, to nostrand ave, where you can catch a long stretch of cascading lights.
Speeding down that street is pointless, because you are guaranteed to hit a red light if you do.