Watching videos of this game makes me happy

Nintendo must be putting a lot of effort into polishing it.

Esit: How did this thread devolve into discussing the power of the Cell? 

Allow me to repeat.

It wasn't involved in setting up triangles, it wasn't performing complex shaders, heck it wasn't even involved in any texturing. (Unless you count texture decrompression with Megatexturing, but that happened on every platform.)

So what was it used for? Well. Anti-Aliasing. It was a post-processing effect that would blur the edges of geometry and it was used to great effect, otherwise known as Morphological Anti-Aliasing, it was cheap.
It would also apply colour filters, possibly do some blur effects, but mostly that was all simple post processing stuff.

People are under the impression the Cell could render entire game worlds, well. It can't. Not unless you want PS1/N64 levels of graphics, it's simply not fast enough for heavy duty graphics rendering, never was.

And you know what? Despite the Cell having "crazy" levels of theoretical performance, that theoretical performance advantage was never truly realised in the real world, in games. - Halo 4 and Gears 3 showed the 360 could compete with the best the PS3 could offer.

Ok, I can agree that half the RAM could affect the LoD or the size of the world. But how much opmization and tricks would make the loss smaller is another point.

Impostering and Streaming can help bolster world size and LoD anyway to the point where it's almost irrellevent from that perspective.

So you would say that is quite possible that Zelda could be put on PS360 without major drawbacks but some consessions right?

There would be concessions.
The most readily apparant would likely be texturing and the lighting.
The WiiU has a more efficient GPU than the Xbox 360 and Playstation 3 to the point where even if it had less flops, it would still be faster.
It has better texture compression, which when coupled with it's larger system memory capacity would be one of the major concessions a developer would make porting it to the other consoles.

And the WiiU also has superior geometry performance, so models will likely be a little simpler on the 360/PS3.

Lighting and shaders will be a big one, the WiiU has the shader grunt to handle more complex effects and more of them on screen.

Overall, it would technically be the same game, but it would still look the best on the WiiU, it's simply more modern and more capable machine than the 360/PS3.

Agreed... but considering it's a cell shaded game and that textures seem simpler than other games worked by PS360, wouldn't that end up becoming a very small concession and geometry diminishing returns also end up as a small concession?

Perhaps end product graphical punch wouldn't differ more than 10% (ass pulled) difference between WiiU and PS360?

Yep it would. Art can play a larger role than graphics fidelity in how pleasing a game can look, really depends how a developer goes about things, hyper-realistic games tend to age faster.
There are some PS2/Gamecube games when emulated on PC can look pretty darn good even today.

Overall, I would be happy to play a Zelda on a 360 or PS3.

One less HW to worry about... but although I would like to have all Nintendo games available on my Playstation (or in your case all nintendo, xbox and playstation games on PC, with only exclusives taking a time to hit emulators) there is a charm to playing the game on the machine it was originally intended to work on.

It requires less RAM for streaming, but the sheer number of polygons and details, and the great use of lighting and textures plus all the enemies on screen at once, it is definitely a VERY demanding game for its hardware and would have been demanding had it been on Wii U.

There are many linear games, but none of them try to do what God of War 3 does so successfully. Just about any scene with titans in the game are damn impressive, as those titans are not just gigantic but also very well animated, and that requires a alot of resources.

Not just that but the particle effects are really good as well, and there are dynamic light sources too, such as when you use the Head of Helios.

Also it does all of this running at 45fps while Zeldaa runs at 30fps.

You know I'm not talking about scenes such as this plus it looks like it has been cropped, as in this particular fight there is a gigantic titan destroying a city in the background nowhere to be seen here.

If you've played the game, there are much more stunning gameplay sequences than this anyways.