Until the directory structure and filename, including your SharePoint hostname, exceeds 400 characters and then it just breaks. Because, Microsoft.

Surprisingly easy to do with some quite nested folders with spaces in the names (as that takes 3 characters per space) and a long filename.