Patients who had probes located in the wrong part of their brain due to failings at an NHS trust suffered unnecessarily for years, a damning report has found.