Square wanted to develop for a console that would run off of a CD, and the N64 did not, hence the cancellation. However, I’ve never heard that they got “near completion” for the N64; from what I understand, they abandoned the project quite early.

I think there was a thread about this a couple of years back in the FF6 section. No idea if it’s still there or not.