I've worked in one project where it seriously did the job and was kind of useful to improve teams performance.

And ye, there were no dedicated scrum masters. Just management guys did scrum mastering each other's teams with friction of their time.

But that was unicorn. Apart from that it's just waste of time and full time scrum masters are such waste of money.

We will be laughing of scrum in couple years from now.