Thanks so much for the thoughtful response! TigerBeetle seems very cool, I hope to dig in and learn more about it at some point. As an aside, your Twitter thread on macOS fsync behaviour was very helpful for me!
If you have time at some point to dig in more, we also did a Zig SHOWTIME intro on TigerBeetle that you might like (https://www.youtube.com/watch?v=BH2jvJ74npM) where we dig into these storage faults in more detail, plus a little Lord of the Rings ;)