Well, always when I run restore, I run restore with no-local-db option, because restoring with local-db is kind of pointless, because … yeah no need to repeat obvious things.
Here is the build (valid for 3 days):
But I do have great news.
2024-01-15 08:31:31 +02 - [Warning-Duplicati.Library.Main.Operation.RecreateDatabaseHandler-WrongBlocklistHashes]: duplicati-i2f4f78e1f1e44044aadd3b82a9c6b315.dindex.zip.aes had invalid blocklists which could not be used. Consider deleting this index file and run repair to recreate it.
It detected offending dindex file and successfully restored the backup.
Just to be 100% sure, I retested with the exactly same command line with the canary version and it fails saying:
2024-01-15 08.44.53 +02 - [Warning-Duplicati.Library.Main.Operation.RecreateDatabaseHandler-UpdatingTables]: Unexpected changes caused by block duplicati-b0366966e93db4129b6ce9f5798fbe9d2.dblock.zip.aes
This is good, really good.
It just makes me smile, how good my educated guesses about the issue causes were earlier. 
Yet as I said, I’ve been there and done that, broken transaction stuff I mean.