Neodegenerate on 15 December 2014
If I had to put them as two options as above I would go with "artistic" and "realistic" as opposed to cartoony. As others have mentioned there are middle-ground games that don't go for that ultra-realism approach that I would classify as "realistic" in this regard that can still look great. Overall, I prefer a more anime style look to my games. I feel that trying to hit ultra-realistic results all too often in flaws presenting themselves too easily. Whereas in a more cartoon/artistic format you have a lot more artistic license to hide those flaws behind.
