We had a fascinating visit to Ripon Cathedral. There's a good mix of architectural styles and historical periods, from a crypt underneath dating through the 600s to the 'modern' font added in Tudor times to coloured statues created only last century.
The guide who chatted to me for a while passed on several pieces of information which I'd love to include in a story some time.
I'm not the only one to have seen story potential. A former canon's son C.S Lewis noticed a carving in the misericords of a rabbit being chased by a gryphon and disappearing down a hole. He later wrote Alice in Wonderland.