2d console games, really the only one I play currently is street fighter 3rd strike on the xbox
nicely organised site showcasing the graphics:
http://www.newwavemugen.com/~zweifuss/index.htmdefinetly my favourite fighter, great controls, great backgrounds and I love the sprites
but really thats about it as far as modern(ish) 2d console games go..
but ofcourse Im still showing plenty of love to classic snes games, and while not many of them are absolutely beautiful, like you said each piece seems to compliment the next, perhaps just now-adays developers are making 2d games with 3d versions in mind
2D games are pretty much dead on consoles, but I highly doubt they will ever dissappear completely. sure I'd expect many years to go by with no 2d games on consoles but I'd never rule out the possibility, the niche alone of a 2d game showing up in a generation of 3d games is a pretty attractive prospect and would attract a lot of attention.
edit-
also four swords adventures, even though a lot of it was pre-rendered, everything fit together nicely, and it seems like it wouldve been fun to be a part of the team that made the game