I’ve seen at least two SMs who were really motivated and they can actually be a tremendous help.
My last project was complete chaos, and that one lone SM managed to get it all streamlined and efficient. Then he was pulled from the project and everything collapsed again.