The Community Workshop was bugged, and all works published recently are not available for download.

Already existing old works that haven't been re-published recently will work fine.

This issue is not only contained to NS2, but all Workshop compliant games were affected.