I like to keep a local copy for any cloud-stored data, and so I regularly pull full backups from Apple's iCloud. On privacy.apple.com you can request a full archive for any of Apple's cloud services. Unfortunately, this somewhat broke in early 2024 and the ZIP archives have been corrupted since:

iCloud Drive Part 1 of 6.zip Decompression failed.
I wasn't able to pull any working archive for quite a while, and since Apple doesn't have a bugtracker for these type of things, here's just my notes on the issue.
At least here, the issue seems to be related to file path encoding.