Travelers might want to avoid these overrated places in the Tar Heel State that look better online than in real life.