AppX/MSI deployment via BigFix Failing on Majority of Machines

Not sure why the error message has an extra ) symbol in the filepath, I'm going to assume a copy/paste error.

Have a look at Tip - Action Override User settings to see whether these tips are helpful. In particular, the interactive user will not have access to the BigFix download folders; you'll need to copy (not move, but copy) the download files to a path the user can read first, and then arrange the install commands to reference the files there.