It's well documented that soft delete is more of a headache than it's worth

https://brandur.org/soft-deletion

Maybe well opined on, not well-documented.

There are clients (ORM, etc) that handle soft deletion just fine in many of the scenarios laid out in that article.