I live in an area that's heavily dominated by protestants, so my experience is mostly with them, I don't know how that's for catholic areas. The Netherlands are famously protestant as well, might be similar.
There are churches, however, where many of the people are there because they genuinely believe it, and they think that they have very good reason to believe it (and they aren't afraid of engaging with atheists who think otherwise), and they try to live out what they believe in real life. If you find a church like that, it feels and acts completely different.
In orthodox churches and especially monasteries it is essentially mandatory to give you a place to sleep while doing some work for them until you get back on your feet.
It also used to be customary for people in villages and towns to always accept a traveler for the night, but not anymore, unfortunately.
Orthodox monasteries larger than a skete are obliged to provide hospitality, but the prevailing interpretation is that this hospitality is limited to three days, and then it is the abbot's call to let you stay further or ask you to leave.