NieR creator revealed that “a lot of projects I was involved in” were ultimately cancelled