Here's a great rundown of some of the world's coolest secret passageways, including "priest holes" (not what it sounds like) and the famous Winchester Puzzle House:

Some of the more elaborate escape games out there include secret passageways that mechanically open in response to your puzzle solving, which is just about the best thing in the world in our opinion!