I can't say I'm keen on cathedrals and the like, but some of the old churches are beautiful.
I used to visit an old church occasionally during my lunch hour. Well, at 200 years old that's pretty old by Australian standards. (Anything older than that would have just been a didgeridoo played in the twilight.)
I'm not even remotely religious but that old building felt so peaceful and had so much atmosphere (in spite of the pews being scarred by the initials of generations of schoolboys who were forced to attend) that I carried some of it away with me. I'll post a picture.
I don't think "modern" churches can do that. The buildings tend to lack character and they're used for all manner of functions and events that tend to destroy atmosphere rather than create it.
But fear? Perhaps believers who fear an eternity in Hell might find them scary but we atheists can just appreciate them for their beauty.