Are the Web Applications under different (Trusted/Untrusted) URLs? For instance the working ones are an internal URL that is trusted whereas the one's failing to open are external, which fall under trust levels in the browser and the network? Differences in the network/browser configurations are very likely to cause issues with the open in explorer view.
Its an older article, however it has some good troubleshooting steps: https://blogs.technet.microsoft.com/manjesh/2010/01/03/all-about-explorer-view-in-sharepoint/ (links are in the referenced article, need moar reputation before posting them here)
Important points to be remembered when troubleshooting explorer view issues
- The Ports 137,138,139 and 445 should be opened between the client and the SharePoint server. We can verify it using telnet 137 and it should connect properly. the same can be done for ports 138,139 and 445
- If we trying to access an intranet site using FQDN, its good that we add the site to the Trusted Sites zone on client computers as a dot (.) in the URL will make IE consider that its Internet and accepts the security configuration for internet zone.
- Follow the KB article {removed} if the error is similar
- Apply if this is applicable {removed}
- If you restart the web client service on the client operating system , its always better to restart the O/S as there are some known issues reported. (operating system prior to longhorn)
- Apply this if suitable {removed}
- Avoid using Basic authentication . Basic authentication will work fine with WebDAV but has reported issues with FPRPC. If used , force web browser to use WebDAV
8.The account BUILTIN\NetworkService must have read and write access to “Temporary Internet Files folder” to successfully complete a drag-and-drop operation.
- Proxies configured in LAN also can cause issues in getting access to the explorer view
- Errors with lengthy URLS , follow this {removed}