Very similar thoughts to an article I wrote back in 2014: https://jameshalsall.co.uk/posts/why-soft-deletes-are-evil-a...

Excuse the dramatic title of the post