The inspection, carried out in February, was in part prompted by concerns raised over an increase in medicines errors.
However, inspectors said they found no evidence that people were at risk of harm and concluded medicines were managed safely and leaders ensured everyone had a detailed care plan in place.
The report said the service was well staffed and ensured people had access to information in different formats and languages.
Inspectors found Rotherham Regional Office put people “at the heart of their care” and said “passionate” staff helped people thrive and develop new skills.
“We heard about staff helping someone to gain employment, another person was being encouraged to take on voluntary roles to prepare them for the world of work and make them feel valued,” Mr Stephenson said.
“All staff should be extremely proud of the care they’re providing to people.
“They clearly work hard to provide exceptional care, and other services should look at this report to see if there’s anything they can learn.”