Another example: A smart contract that transfers ownership of your online accounts to someone else in case of - say - death. Sounds reasonable, but who tells the smart contract that the person died? The coroner? If so, you are back to square one trying to solve the trusted third party problem.
Ironically for Web3/etc. the "(no) trusted third party" is both the selling point and it's largest problem.