That's a good use case as a candidate for Where Used relationships. For Sites 9.5, we explicitly looked at Where Used as the check for the things that would prevent a user from deleting some item in the system. We actually removed some items from the lists that didn't actually prevent deleting the item in use.
A possible improvement to deletion would be a sort of "deletion wizard" or more powerful Where Used that let a user go through a process to delete an item, respecting user authorization settings while confirming steps along the way.
To help this idea along we could use votes as well as more use cases and feedback. How often does it come up that you can't delete a folder or some other item? Would additional information help?