When extra3 had a segment on these red lights in their "Der alltägliche Irrsinn" ("Everyday madness") series, they said that there were three such lights in Dresden. I only know the one at Wasaplatz heading into Oskarstraße. Let's see if it survives the upcoming redesign of Wasaplatz this year.