I've been using iCloud sync with Obsidian for a year, and it has worked perfectly. Correct, you don't get to put your folder anywhere you want. It has to be in iCloud Drive, but so what?