I can only speak for Switzerland and a bit of Germany. It does look way better as soon as you enter the countryside. On paper, I would estimate that we have, on average, 15% foreigners in small towns, which in reality you can double to 30% on average to get the realistic number. As I said before, a Turkish man with a Swiss/German passport is still a foreigner in my world but not for the statistics. The 'good' side with foreigners in villages is that they, on most parts, really try to integrate, and mostly they are better educated. They also tend to be against mass immigration (that's why they left the city, same reason as the native). In most small towns, still a lot of people vote for the right party, but it's declining as well. Keeping bad immigrants 'in check,' I do feel no one has the balls to do it, but the quality of foreigners again is way better in villages. I would predict if you find a small conservative voting town in Europe, you can still 'survive' there with your family and have a good Christian life for 20-30 years, but at one point, it will all break down, so better be prepared.
No-Go Zones do only exist when the government decides to put an asylum seeker home in small villages. People then rightly so are afraid to go out. Those incidents do happen.