Okay, Zelda will never appear on a Sony console. That series is wholly owned by Nintendo and only one game from the series has ever appeared on another platform, and that was the Phillips CD-i about 10 years ago. The game failed miserably, so there is less than a 0.0001% chance that anyone will ever see Zelda on another system.

As for the new Zelda, it's going to be awesome. The world itself is easily 10 times the size of Hyrule from Ocarina Of Time, and it's actually a much longer and more involved quest than any in the series so far. I've heard and seen nothing but good things about this game.

And FF9 was not a kids game. You could say the exact same thing about FF7 because of how similar the art styles are in both games. FF9 blew everything else in the series out of the water.