There are favorites of mine for character and world design (Yoji Shinkawa's sci-fi military designs; pretty much all of the Metroid games), overall style (cel-shading in Killer7 or Okami's painterly look, or the high contrast in MadWorld), etc, but I can think of two times where I was blown away...