iCloud Drive FAQ raises more questions than it answers

I am tired of seeing statements from Apple stating that any file or folder can be stored on iCloud Drive and then kept up to date across all devices. As far as I can see this is simply not true. iOS has no file system as such, so you simply can't see files that aren't associated with a particular app. Another question I have seen asked by a number of people and to which I have seen no satisfactory answer is: where is my iCloud Drive folder locally on my Mac and is it backed up by Time Machine?

iCloud Drive is a total mess. Why oh why oh why didn't Apple just go and buy Dropbox. With Dropbox I know exactly where my local folder is and it is backed up with Time Machine. I can store any file I want and see it either through Finder on my Mac or Dropbox app on my iOS devices. If I want to open a particular file on an iOS device, I simply use the 'open in' and it's job done.

One thing that would make a massive difference here is a Dropbox like app for iCloud Drive. It wouldn't fix all the problems but it would go a long way to making it actually usable. Are there plans to do this?