No, would of preferred they stuck with the original style than change it to what it is today.

Definitely not. I think it might be able to, but no one cares enough to do it. Too pricey, I guess.

YES:

dont look at the whole picture but look at the small details.

You're certainly not alone there. The teaser graphics were much more mainstream-friendly.

No, but...

Still amazing imo. I actually didn't like the artistical direction of that Zelda demo. Not a fan of the games in the series that try to make it exceedingly realistic. 

Edit: I actually change my answer to yes, because I don't find that demo particularly impressive personally. I like the look of all the games I posted more.

Don't use that footage of the SMT game. It makes it look like a 3DS title.

Care to elaborate?

Changed it to Fatal Frame just for you.

Everytime a console is revealed, we always get tech demos showcasing the console's potential. Key being potential, because said tech demos are always just pre-rendered videos, which of course always look better than anything real time, even if it's in engine. Wii-U might get something close, maybe even from Zelda U, but I doubt anything on Wii-U will ever look that good.

That being said, I really wish they had stuck with the darker Zelda style from that footage. I still can't get on board with the brighter more colorful style.

I'd say if not, thay have came darn close. It will be passed before the gen is over.

EDIT: If we are just talking about preference, yes many times including the new Zelda U trailer (due to it saying visuals).

Not to mention this https://www.youtube.com/watch?v=Shch7LNkVXw