I have mixed feelings on post deletion. On the one hand, historical technical forum conversations are an incredibly valuable resource, and /c/selfhosted is a technical community. The value comes from having a history in context, and deleting part of the context damages the whole and makes the whole corpus less useful overall. It also allows incorrect or outdated information to fester when there isn't a strong historical context that can be referenced.
On the other hand, people are right to be concerned about leaving large tracts of text available on the open internet, where it can be scraped, profiled, and possibly de-anonymized. I am very sympathetic to those who delete out of concerns for their own privacy, and I don't know what a good solution is.
Maybe a compromise would be (on user "delete") to leave the contents of a post intact, but simply delete the username from the post, and the post from the user's history? Deletion on the fediverse is a bit of a sham anyway, and it would leave valuable discussions intact for other users.