I looked into this some more. There are other ways than explicit fsync. See this blurb on FUA (which basically treats the I/O as write-through)
https://techcommunity.microsoft.com/blog/sqlserver/sql-serve...
More from kernel.org: https://www.kernel.org/doc/html/latest/block/writeback_cache...