Hard deletes also can cause chaos and issues. I've got a data warehouse with much more complicated ETL because the source system does quiet hard deletes... Which really throws a wrench in reporting on the state of the business.