Retro Gaming on HDTVs and Video Connections - Game Sack

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?.