Games with great Artistic Style

[ATB]

Naturally, the topic stems from my playing the beautiful Okami.

But I've also been working through Killer 7, which is a stunningly achievement in stylized gaming.

Other great artistic games, imo:

MDK series. It was uniquely whacky and wholely underappreciated. Both games, but especially the second, were beautiful

Giants: Citizen Kabuto- Again, whacky, but a great artisitic style that has stuck with me.

Phoenix Wright: True, it's pretty much straight anime, but it works so perfectly.  I love how the characters were drawn and how their reaction animations fit their personalities perfectly.  My favorite character, Damon Gant is just something to behold. 

[Kevin Grey]

Prince of Persia: Sands of Time (I don't include Warrior Within or Two Thrones)- When I first played it, I thought "this game looks just as good as it wants to be" and a replay late last year still held that to be true.  I really can't imagine the game looking much better. 

Viewtiful Joe- another very stylized game from Okami developer Clover

Contact- From Killer 7 developer Grasshopper

SMT: Nocturne and Digital Devil Saga- very striking, sterile, and creepy design work.  Even "normal" environments in these games feel very unsettling.

Sly Cooper series- Along with Zelda: Wind Waker (see below), probably the best use of cel-shading I've seen in a game combined with a perfect noir meets looney tunes feel.

Zelda: Wind Waker- perfectly realized to me.  I'd love to see another Zelda game in this style.

Zelda: Majora's Mask- very bold step for the series and makes this another very unique outing for Zelda

[wonderpug]

Ico
Shadow of the Colossus
Grim Fandango

[Kevin Grey]

Ico
Shadow of the Colossus
Grim Fandango

Holy crap, no idea how I could have forgot those. 

EDIT- Oh yeah, Yoshi's Island is a must for this list too!

[The Grue]

Not all of these are console games, but some additions to your list:

World of Warcraft
Alice
TRON 2.0
Psychonauts
Paper Mario
most cel-shaded games

[EngineNo9]

Jet Grind/Set Radio games
and my others were just stolen by The Grue!

[The Grue]

Just thought of a couple others from the handheld scene:

Exit
Ouendan
Lumines

[SjN]

When I hear the words 'Artistic Style' one game comes to mind - Assassin's Creed. If you haven't seen the trailer for this game, I highly recommend it.

http://assassinscreed.uk.ubi.com

The cinematics of this title are nothing short of amazing. Although I haven't had the opportunity to get my hands on it to take it for a test drive, I can only hope that the gameplay is every bit as good as the eye candy displayed in the trailer. This once PS3 only title was recently announced that it is coming to the Xbox360!!

--SjN

[Dreamshadow]

In the other direction,  Katamari Damacy, We (heart) Katamari, and Loco Roco have great style.  The style comes from a fusion of the music and the art.

[Farscry]

Some games I personally love the art style in (off the top of my head):

World of Warcraft
Dragon Quest 8
The Legend of Zelda: The Wind Waker
Dark Cloud 2
Vagrant Story
Chrono Trigger
Street Fighter 3

[Doopri]

ill second MDK and Giants (man, does anyone remember the gleam on the helmets in MDK, when you would zoom in with the sniper scope! that game was great!)

as well as alice (course im a fan of it in general as well)

also - otogi was pretty neat and i cant believe no one mentioned panzer dragoon orta

[wonderpug]

Ooh, almost forgot:

Day of the Tentacle

[Sparhawk]

World of Warcraft (From the music all the way to the animations)
Ico
Shadow of the Collossus.
Warcraft I, II, III
Myth I, II
God of War
Final Fantasy series
Dragon Quest series

[depward]

SMT: Nocturne and Digital Devil Saga- very striking, sterile, and creepy design work.  Even "normal" environments in these games feel very unsettling.

I thought no one would say that!  All of the SMT have incredible artistic style.

[EddieA]

In addition to those mentioned, Baten Kaitos has absolutely beautiful backgrounds.  There's a huge variety of environments, but they all fit due to the quality art direction of the game.  As for the SMT series, the amazing character designs steal the show.  I love Kazuma Kaneko's style.

[Andrew Mallon]

I'll echo a lot of what has already been said, especially Sands of Time. The art direction in the game  perfectly matched the tone of the game. One moment in particular is a perfect example of this. Early in the game you walk out on to a balcony where there's a full moon. It perfectly sets the atmosphere for the game. Shortly after that, the game pulls back from the balcony and shows you the tower that you'll eventually have to reach the top of and the enormity of what the Prince must do is perfectly brought in to focus. What a great game.

A couple that I haven't seen mentioned are Chrono Trigger and the Thief series. Chrono Trigger is especially notable for its use of color and the sprite animation. The scene in CT when Chrono returns and one of the characters unexpectedly runs over and hugs him is just perfect. There's more emotion packed in to that moment than in all of the combined story sequences of most games. I also love how the game colors different areas to reflect the different time periods. The lush greens of the past with the metallic grays of the future settings.

While the Thief series is very dated now, it's use of shadows and sounds still make it one of the most atmospheric and fun series of games to play. Hiding in the shadows and listening to guard conversations and footsteps will always be fun no matter how advanced game graphics get. Great, great series.