Make no mistake, this is just a covered bridge. Traffic still passes through it so don't expect to be able to just stand around in the middle of it or let your kids run wild as they might get hit by a car. The road isn't generally that heavily traveled but during foliage season it will be.
The only thing that really makes this bridge a worthwhile stop is its haunted history. There are several different versions of the story told by the locals, but the basic premise is that a young women named Emily died on this bridge on her wedding night. Some say the horse bucked her off on the way to meet her future husband. Other stories say that her lover never showed and she hung herself in the bridge or jumped over the side of the bridge killing herself on the rocks below. Many people claim to have had experiences on this bridge. I used to go there alot to "ghost hunt" when I was a kid. I have never seen or experienced anything. If you go there after dark be prepared for groups of teenagers out there trying to catch a glimpse of Emily.
Overall, it is a fun stop if you are already in the area. But I wouldn't make a special trip to see it.