What, if any benefit do they actually have on the city?
Because I instantly demolish them whenever I see one so's I can make room for more important buildings.

I heard they raise land value although I never really checked if this theory is true or false. I just demolish those near my downtown, only leaving one as the main cathedral of the city. I like to see them pop up in my low densed residential areas. They just look nice .