Would you say they encourage a vibrant street culture of cafes and shops?
The ones I've seen, especially in Berlin and İzmir, are loud and a hassle to cross. That's because walkways and bikeways over multi-lane roads are car infrastructure. They are there to prioritize high-speed automobile traffic with few interruptions. I'm happy for the one going up at my gym, but I know it's there to ensure bike/ped political forces can't endanger the trunk road underneath. True pedestrian infrastructure there would involve a major speed and size downgrade to the road, which is unacceptable, thus the political defensive move to pay out the nose for something car advocates would never normally fund.
Pushing a stroller for the last few years, plus spraining my ankle a few weeks ago has given me a little taste of what trying to use sidewalks is like for people with even tighter mobility constraints, and this in an area that is relatively accessible without a car.
Otherwise, what you're describing sounds like someone looked at this well-circulated cartoon and said "hey that's a great idea! Just raise the planks by 15 feet!" https://www.vox.com/xpress/2014/11/18/7236471/cars-pedestria...