That's why I asked about it, I don't know how filepaths are handled under the hood of popular game engines like Unity, but for my own small application (not a game) I wrote for my own specific needs it was enough just to enable long path awareness in the application manifest. I don't use fixed string buffer sizes or MAX_PATH Win32 constant in my code, if I did, then it wouldn't probably work.
Of course, Windows prior to Win10 1607 won't recognize long paths even with this feature enabled in manifest, but it at least can mitigate the long path issues on modern Windows versions.
By the way, NTFS itself supports paths up to 32767 characters, if I correctly remember the specifications.