Hmm, how about SPN does Amityville? With the real story and horror being not too far away but just obscured enough to have been hidden all this time.

Though I suppose SGA with Famous Haunted Location of the Pegasus Galaxy could be cooler, especially if it's a place so well known and Ronon is wary of going there after attempting to hide there previously as a runner but won't talk about what is there or why he left quickly.