Mapping the demise of collective motion in nuclei at high excitation energy