I don't know if it is necessarily ghoulish, but Old Newgate Prison in
Connecticut gave me nightmares when I was a child.  It is an underground
prison which was carved out by prisoners.  There is a guided tour and
plenty of tales of escape.
 
Laura Paskus