Looks like this is FINALLY being addressed although why it took 3 years I've no idea:
New Feature: SharePoint File Delete Lockout override
MC208414,
We've gotten a lot of feedback from people who are unable to delete a document because they had it open in another tab on a different computer, or because someone else had it open and forgot about it, effectively locking the document. This
feature allows you to override that lock and delete an Office file (such as Word, Excel, or PowerPoint) when you or someone else has it open, whether intentionally or not. The new functionality will be available to people who want to delete items from their
own OneDrive, and to all members of a document library who already have permission to delete files.
When this will happen
- We'll be gradually rolling this out to Targeted Release customers in early April.
- The roll-out will be completed to all customers by the end of April.
This message is associated with Microsoft 365 Roadmap ID 62665
Love this rather self effacing excuse which clearly isn't the truth - as Msft has themselves said files were getting locked when they
weren't open anywhere else :
"people who are unable to delete a document because they had it open in another tab on a different computer, or because someone else had it open and forgot about it, effectively locking the document. "