iCloud Drive in Sonoma has changed beyond all recognition, and is now closely integrated with the FileProvider API. This has important effects, including how you can diagnose problems with the log.
FileProvider
Two different errors when backing up two different Macs, a recursive RTFD document, and APFS path length limits. But what’s this about FileProvider?
The Eclectic Light Company 