I think it probably depends on the city and maybe even the intersection. Here, when they're working (not a given) you get a walk signal (whereas if you don't push the button it stays a solid do not cross hand). Additionally, the length of the green light is potentially extended to allow enough time for pedestrians to cross.

There's even one intersection here on a road with designated and flimsy bollard separated bike route where I can be approaching on my bike in the bike lane and it notices me and turns the light green for me which is super cool.