I only assume you refer to the pre 2000 state of Office. Confusion started way befor AI.
And to me the OneDrive - was forced on my in the job - was never a properly usable product, allowing others think differently, but to me, its weird ways and failures (i.e. renaming files) are jus barriers to efficiency.
I have always been puzzled by the threads since it’s a mess with a bad UI with bad default locations for the various programs.
I understand OneDrive as Microsoft’s version of Dropbox, but the more it’s integrated into Windows/Office, the more confusion it causes me.
I had uninstalled OneDrive the first time I used this laptop. But that wasn't enough. I had to reinstall OneDrive. Turn off folder backups. Unlink the PC from OneDrive. Then uninstall it again. That fixed the two Documents folders problem. OneDrive\Documents went away and the contents put back into Users\username\Documents.
A fairly frustrating experience and wasted about an hour troubleshooting it.