I don’t think the criticism is new here. Here’s one thread where we were speculating about why it’s not great from late 2021, for example.
There’s still plenty to do in iCloud Drive even if not using the quirky Desktop & Downloads sync, too. I have plenty of per-app data/documents in there. It works fine for anything you need to eventually show up everywhere, and for which you don’t need collaboration features.