The physical files in the storages, either Local Storage or S3 Pro, referenced via Attachment field interface type or File Collection, shall be deleted when users click on Delete button.

And prompt the users for the confirmation that the files will be deleted permanently.
Advantages:
- To prevent orphan physical files remain in storages.
- To prevent unreferenced File Collection records.
- No scheduled clean up job required.