The only solution is a decentralized database and every user can choose their own moderators so different users see posts deleted and some don't. Then everyone has freedom to get their way.
This used to exist, in a rudimentary way: usenet, and NNTP.
For the younger ones:
https://en.wikipedia.org/wiki/UsenetOne notable difference between a BBS or web forum and Usenet is the absence of a central server and dedicated administrator. Usenet is distributed among a large, constantly changing conglomeration of servers that store and forward messages to one another in so-called news feeds. Individual users may read messages from and post messages to a local server operated by a commercial usenet provider, their Internet service provider, university, employer, or their own server.