Syncing across Creative Cloud - a bit

Adobe, I love you. I use you everyday and I admire your capabilities, growth, progress and your continual revolutionising of everything graphic design, image and video editing.

However, unless I've badly misunderstood it (possible but unlikely), your current system for syncing assets across your Creative Cloud System is chaotic to the point of being unworkable.  I'm sorry it is a bit 

What is the difference between Synced Files, Cloud Files, Libraries and my Lightroom storage?

Where does my Lightroom storage even live and why can I not see it locally?

Why can I not move a file from Synced Files to a Library?

Even better, why can't I sync a Library directly from a Synced Files folder?

Why do some apps use some synced locations but not others?

Why can I not access my Libraries or my Synced Files from Photoshop?

Why can I not access my Synced Files from CC Express on an iPad/phone?

Why do I need four different cloud locations?

Why can I not access my Lightroom Synced Folders directly in my Libraries?

Why can I only upload a file to a Library and not sync it directly from either Lightroom or my Synced Files?

Like I said, unless I've significantly misunderstood the whole ecosystem, or you are deliberately trying to make it as confusing as possible, it's all a bit of a mess.

Please can you sort it out?  I can't believe it needs to be this complicated... I really can't.

[Profanity removed by moderator.]