Ya know, I've personally really gotten tired of amazing graphics. Yes, I know that sounds nuts, but just let me explain.
I go to IGN and I check out every single section; PC, PS2, PS3, Xbox, Xbox 360, DS, Wii. Other than the DS and Wii, all have previews and reviews of games that are packed with bump-mapping and particle effects and physics and blah blah BLAH! Everything is shiny and textured to death and guess what, except for a few, none of them really look real. Half-life 2 is really the only game that could be mistaken for real life. Almost every other game I see, I would never say "Woah! That's a video game? I thought that was a sci-fi movie! Are you serious, that's really a video game! I can't believe it!" It's not that these games don't look good or aren't getting close to photo-realism, but they still aren't there and most likely won't be til the next gen or next next gen.
All the FPSs are just looking the same, simply with different characters and weapons and worlds. I mean, look at Spore! Sorry, but there is no other game as anticipated as that game and guess what, it doesn't look nor try to look real. However, I hate when people say it's ALL ABOUT GAMEPLAY! If it were, then blind people would be able to play games. Graphics are very important in illustrating the story that's being told. What if the movie Saving Private Ryan or Scarface were recorded using a RAZR cellphone? They wouldn't have the impact and they wouldn't take you there.
I think the best console game I've ever seen is Splinter Cell: Chaos Theory for Xbox. It's simply amazing how real that game looks and feels and sounds. Wii will have graphics atleast that good or better. That's good enough for me.
*EDIT* Just look at these new screens of Red Steel.