It’s no different from living in a beautiful natural landscape. I can tell you from experience that no, you get used to it.
It would not be a lot. It would fade into the background, except that any time you want to see beauty you just have to look up and focus.
nature has proven calming effects on humans... bird sings, even plants on the roof of an urban area can have positive effects just because of the vision
i highly doubt a christian church has the same effect. everytime i see a church i think about atrocities commited by the religion and alienation