One particular use-case that stayed with me for a long time is what DeBeers is doing with the diamond tracing. For long time diamond certificates were faked between Afrika and Antwerp, especially on border checkpoints. This is where blood diamonds were introduced into the supply chain. Participants cannot be trusted and a common ledger (a.k.a Blockchain or DLT) is a solution. With a traditional database you'd have again a "super administrator", which is exactly what you want to avoid. This has, obviously, nothing in common with a public network like Ethereum, but it's still "Blockchain" and I believe it's still a very valuable real-world use-case. https://www.tracr.com/
Paul Brody does also a lot of real-world projects with EY.