I can only speak for places I've visited, but many Belgian towns are highly accessible by tram and cycle routes and come to mind.

La Panne / De Panne, Oostende, Knokke-Heist, etc, all have quite vibrant town centres, seasonal events, food markets, playgrounds, free-to-the-public pétanque/boules courts, you name it.

Then in France, Strasbourg has completely pedestrianised the town centre, which is similarly successful, although a little more touristy as you say - nice places attract tourists and shopping, it's unavoidable!

[delayed]

If we're talking about shopping streets, almost 100% of them. Towns of a few thousand people have pedestrian zone shopping streets. (They are usually not doing well in small towns.)

Much of the city area, not many at all. Superblocks in Spanish cities come to mind.