Hahaha it's more beautiful than terrifying actually. I think it depends a lot on the location, but going into this place is very common in Paris, it is a tourist attraction, as strange as it may seem.
Hahaha the scariest thing I came across were those crows that stared at you when you approached to take a picture of them.