I had mod_python enabled and it would give me 404 on random python scripts in downloads directory (not cgi)…
Nothing in error log either!
Here is the fix:
put .htaccess file in the download directory with following contents:
<Files *.py> RemoveHandler .py AddType text/plain .py SetHandler none SetHandler default-handler Options -ExecCGI </Files>