UN secretary-general Ban Ki-moon has visited victims of devastating Hurricane Matthew, saying the destruction wrought by the storm was "heartbreaking".