Most of these are the bigger late model flatscreens, so I don't know how good they are compared to the older curved tube models.
"Domed" CRT TVs are the way to go man, plus you can use light gun (Zapper) games with them!
If you can find a good dome TV that accepts composite video you can run the A/V cables from game consoles that support them, otherwise use an RF modulator. My used game store has a ton of cheap RF modulators that piggyback on the A/V connector at the rear of the game console, however a quality stand-alone RF modulator purchased at retail will often yield a superior signal with less color bleed, compared to most 3rd party "accessory" modulators, or sometimes even the stock modulators built into the 8- and 16-bit era consoles, at least those ones that had a choice of video outputs.
4th generation (SNES, Genesis/MD, Turbo) and down, use a CRT. 5th generation (N64, PS1) and up, use an LCD TV for superior picture. Although I will say this, if you have one of those rare LCD TVs that still supports S-Video, absolutely nothing compares to the clarity of SNES with an S-Video connection, par none! However, if you do decide to connect an old game console to the shiny new widescreen, please make sure to adjust your aspect ratio to 4:3 pillarbox mode...
Currently in my bedroom I have a ultra low-latency ASUS 1080p LCD monitor that I use for all my HD systems (Wii-U, PS3, and Ouya) and a CRT set for all my retro consoles. Unfortunately the LCD monitor doesn't support composite so I have to hook up the Game Cube and N64 to the CRT which still isn't bad. Hint: For HD consoles, 1920x1080 PC monitors generally have much lower latency than most HDTVs, and no overscan!