I think this applies for most of the Europe other than south, though smaller the town more talkative the people I think, in villages with nothing to do are people more likely to be curious about the stranger or just having small talk.

I live in tourist Prague, pretty much never talking with someone other than when I see someone clearly struggling with directions in public transport and I see they go out of the tourist city center I just confirm whether they know it, most of the time* it's not what they intend to do.

*Germans being the exemption, seems they like to do whole team line grim the end to end to see the city even when it's not touristy, for these I have recommendation of some rare above the ground subway sections