In modern gaming I only prefer this one style:
Vibrant lively colours of jungle green, sky blue, sand, bright colours of sunsets, and so on. Far Cry 1 and
Just Cause 2 does good job here. (didn't find better picture right now sorry). This relates to my taste of action films of the 80's, which looked happy and uptempo compared to modern grey/brown/darkblue/michaelbay POS. I want the same experience of my modern action gaming, thats why I also downloaded John Rambo mod to JC2 to get rid of that lousy modern action hero stereotype. Expendables, yes I loathe you too.
In simulations I prefer maximum possible realism. And
iRacing has definitely made a benchmark here. All simulators what ever the genre, should follow immediately and build upon that. Its not about art in a sense, its about simulating reality. Btw. GT5, Forza, Shift, and these are not racing simulators, they are modern crap with all the post processing filters and all sorts of "artistic impressions".
Other gaming from the past:
Doom definitely did it for me from artistic stand point. It had very interesting world with nice pixel graphics. It is a true showcase of real artists making a good game. Even its dark, it is full of red. Very atmospheric.
Super Battletank is effort of trying to make realistic graphics in a low level system like SNES. I have always loved realistic graphics because it really helps to create the immersion of "being there". Luckily since then graphics have gone forward and reality is even much more realistic now. But still, the style which Battletank represents never goes old. It is sleek, beautiful and has a purpose. Many other games of that era looks crap. With even limited palette, resolution and 2D, you can do miracles in means of realism.
Max Headroom. I always loved Spectrum's graphic styles over C64. When working with just two colours, nothing beats bright green on black. It is simple a future of world. You can do anything with it, and it would always look great. Okay not everything as you need indie hipster to fail that one. Great, simple, futuristic and does the job well.
Virtua Cop is lovely. Thou Virtua Fighter having same graphics, I always liked this one more because it has more to do with real world. It is one of the few 3D art styles from 90s that appeal me. It looks vibrant, fun, and even realistic in a way. Sure it was more realistic back then than now, but it still looks awesome fun. Which is all that matters. It is like True Lies - the game. On a sidenote, Terminator Future Shock is maybe the best fully 3D game from 90s in means of art, atmosphere and overall experience (forget to include picture of that).
Super Contra holds the artistic peak of in 8bit/16bit action. I had trouble deciding if to include picture of NES or SNES version, but eventually SNES version being little more overboard than the NES, I used that. It has great Konami-mastered arts and the setting is perfect: "Rambos" fighting in jungle against robots and aliens. If that would be a film made in 80s, it would be great. But now its also great game. Definitely has artistic approach in all aspects which can be never surpassed. Perfect aesthetics.
Barbarian really shows all what is good in fantasy genre. Conan figures fighting each other brutally. Thats perfect, and how it is done in this game is also perfect. Big figures with muscles and mullets, blood and limbs. Not to forgot beautiful sceneries pumping up the atmosphere and lovely GUI (if that even matters ever). Basic gaming done perfectly. Any other fantasy-setting stuff than this is childs play for wimps.
4D Sports Boxing is definitely a showcase of meaningful graphics, that automatically turns into art of functionalism. This is the few rare cases when some sort of graphic style is chosen because it absolutely makes the game itself. I know the game has not been developed that in mind, but that is what happened here. Hipster indie developers making indie physics puzzle games with "artsy" graphics should look right here
how it is really done.
And finally:
I wanted to include one and pretty much only example so far, of a very artistic game which has a sort of "high culture visual appeal". That being
Another World of course. I usually loathe games that tend to be "different" and "artistic" because their artists quite clearly lack any skill and vision. And here is one kind of benchmark for you, very beautiful and surrealistic approach which doesn't look cheesy, not too alien, and not too normal. Perfect in "artistic games" area. I always liked this game because how it looks, while actually had major problems to play this game because being so hard.
And some things I dont like. Usually I don't like 90% of the stuff being made, but these following "experiments" really falls down to the bottom of the deep dark smelly hole. Hopefully suffocating and dying from all the rest crap there.
Actually
Leonelc already posted few pics of 3D styles I absolute hate. Thats some horrible stuff there. Its lousy, cheap, UGLY, and looks crap. "Comic" style doesn't even fit in comics, so definitely not in games and even more not in games of being FPS. Why? Because I want my FPS games to bee realistic immersive experiences (ArmA2), not lousy artistic gimmicks.
And then there is this:
That is just so depressing awful. While nicely made and consistent, it just is so wrong in every aspect. Games should be about testosterone and immersion, manhood and action, fights and blood, porn, all the COOL stuff. FFS flowers and what are those some teddy bears there? And a main character who looks like what, a university student from 40s? Thats just gay there. Why being gay when you could be Tom of Finland style super-homo-male. God damn hipsters making games.