I think Extra Credits summarized this best in Graphics vs Aesthetics
What I'd really like to see more out of games is the same sort of approach Pixar does with CGI. After Final Fantasy: Spirits Within, no one was going into the CGI moviemaking business in an effort to make super-realistic-looking, human-like performances. The easiest way to get that was with real people. Pixar, instead, focused on a lot of cartoony, stylistic appearances of their characters, and generally came out on top, EVEN when they were doing dramatic human-focused moments like the first 5 minutes of Up.
Things like Borderlands and Team Fortress 2 are great steps in the right direction. Frankly, though, I don't see any particular reason why someone couldn't give a stylistic appearance to a realistic modern war shooter. (It would have to be the right style, of course, but it could give it a lot of distinction)