Presumably using an enterprise-grade NVMe SSD with power loss protection capacitors would avoid such trouble. Some of those have reasonably low power consumption under load, but they're all bad at idle compared to client/consumer SSDs. But now you also have me wondering about Intel's Optane cache SSD modules, which like enterprise SSDs don't have any volatile caching, and they're also cheap enough to make some sense in an RPi context. I'm tempted to do some voltage margin testing on one to see where it browns out compared to a typical consumer SSD.