Personally no.Not because I dont find the cartoon based art style is bad(I actually find them gorgeous and BOTW is simply breathtaking), but I am just as impressed with a more realistic approach.I think the best scenario is when they intertwein betwenn the two artstyles.That would be perfect.
In fact, I hope the next Zelda be inspired by Majoras Mask(by that I mean be a more dark game) and uses a more realistic artstyle.That game would be amazing
Edit:Just to clarify, the realistic approach would be in the same vein as Super_Boom said:It just take a more serious approach to the artstyle rather than photo-realism.
My (locked) thread about how difficulty should be a decision for the developers, not the gamers.
https://gamrconnect.vgchartz.com/thread.php?id=241866&page=1







