I personally feel this is largely dependent on the cables and the TV. I have a 50" Sony HD and my nes (via composite), my SNES (via s-video) and my dreamcast (vga) look great. Your cables are incredibly important--and is making sure your TV is properly calibrated.

For me, its all about Final Fight in 50" pixelated glory--beautiful!