Users want Delete/Undo button for their content and actions. Without this feature you are not really in full control of your content.
Hive does not have that feature.
I don't about LBRY.
Sia Skynet apps could unlink deleted content from data structures and interfaces but bullies could possibly still pin the blob and republish it but I think this is about the same as taking a screenshot of a tweet.