Would like more information about hard-deletes

Community Contributor
I apologize if this question was asked before, but I couldn't find anything relevant online. I understand that soft-deletes are treated as a data 'update' , and therefore checking some attribute in the record (e.g. status or workflow status) should be enough to tell whether the record has been 'soft-deleted' or not.  However, hard-deletes are less clear. Specifically, where do they fit in the normal lifecycle of Canvas data?  (that is, when do they happen?, how common are they?, should we expect that every soft-deleted record will someday get hard-deleted?). Etc.