Obviously, 99% of the people who might abuse such a "right" are PR groups working for corrupt politicians and corporations; there's no way this is going to be useful for the average person.
This is also a huge pain in the ass technically. It is simply very hard for most sites to enforce arbitrary censorship, and we know how wonderful DMCA takedown requests have been. At least with DMCA requests and more common censorship laws (against proscribed political beliefs, pornography, etc.) there's a fairly limited scope of things that site operators have to worry about.
And this is censorship; that much is clear. You are forbidden from speaking about people who have the wherewithal to leverage this "right". These aren't even anti-slander laws; under the "right to be forgotten", you are forbidden from making even perfectly true statements about someone.