I have had the good fortune to visit several famous churches, including the Vatican, Notre Dame, Sacre Couer, and quite a few in Canada in Montreal and Toronto. Catholic and Anglican cathedrals are always aesthetically pleasing, to atheist and believer alike.....since I was not religious at all when I first attended one of these churches, I simply experienced a deep reverence for the breathtaking artwork and architecture.
I would love someday to see such places. Of course where live I've only seen pictures.
Unfortunately the only church experiences I've had were at newer churches in the area. I'm not a believer but I was there for a few plays in support of my friend who's kids attend the attached private school. The place was like a mini town with Movie theatres, food courts and the like. I couldn't imagine that Jesus would ever approve of such a place.