Churches aren't like that in Europe. They are not communities nor are they huge. A church is an office where a priest and maybe some assisting staff work, and the priest performs weekly some ceremonies. But there is really no community as such.
This might depend heavily on the country and location, but that's not my experience. I'm not religious, but I know some people who are, and their churches are quite active in their local communities, doing charity work, helping the homeless and the poor in general.
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.
The churches that are full of people who attend church because their parents did are, as you so well put it, sadly waiting to become obsolete.
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.
I'm in Northern Germany. The planned/willful obsolescence here mostly applies to the "official" churches imho. The smaller, free ones tend to be a bit more radical and more grass-roots oriented, so they're more hands-on (which probably also has to do with them not having a lot of old wealth and close ties to the state).
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 churches do not feel obligated to provide lodging. Sure, some parishes will let the homeless bed down at night, but this is a small minority, and in general Orthodox parish priests would prefer you take advantage of homeless shelters instead of expecting lodging from a parish church.
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.
That's a huge generalization for something that differs so heavily even within countries. Cities vs rural, east vs west, catholic vs protestant... Compare Poland and the Czech Republic, both V4 countries, neighbors, former Eastern Bloc, yet one is pretty much the least and the other one of the most religious countries in Europe.
