Death Yard in Hendersonville is supposed to be real good, along with Monster Mountain in Millersville. Really the only two that I know of besides that Slaughter House or whatever downtown...
We went north to a strip mall that had railroad tracks near it. Best one I have ever been too and I freaking can't think of the town it was in. It was more creepy/spooky than animated things that jump out. Hopefully it will pop into my head in a minute
Haunted Woods is out in Columbia. By far the best I've been to around these parts. They have different tours, one for the kids and that scare too easy then one that is just plain awesome...