I unfortunately had to use Windows last year, and the whole mix up between local folders and OneDrive folders meant that the only way to not go insane was to avoid using those folders altogether, create a C:\MyStuff folder and store everything there.

I like this video of Jonathan Blow ranting about the file explorer: https://www.youtube.com/watch?v=le6dvr95Z2Q