Retro Gaming on HDTVs and Video Connections

Want to hook that old-school gaming console up to your spiffy new LCD or Plasma HDTV? Or would a standard definition CRT be better for your retro gaming needs? NES - Kid Kool, Gumshoe, Marble Madness, Mega Man 2. SNES - Castlevania Dracula X. Genesis - Ys III, Sonic