If you're sharing the repo, then you'll have to convince everyone to discard their copy of the original history and accept your modified version. And if that's done and everyone accepts the new history, the original can still be kept in each copy of the repo on another branch and the rewrite seen in the reflog. If commits are being signed, you can keep undeniable record of who contributed what in the original history, and who rewrote it.

If the point is to forbid you to modify even when you're the only person working on it, any common database will allow you to update and delete when you enter with administrative privileges, so I don't see the difference.