My SNES has an S-Video mod but hasn't been modded for RGB (yet). However, mostly I use my Wii outputting 240p via component cables, which is plenty sharp. My 27" Sony has been tweaked up for color, geometry, etc... so it looks as good as I can make it. From what I gather, PVMs have a somewhat different look than consumer Trinitrons, with some difference of opinion as to which is better; they are also limited in size, with 20" maximum. I did enjoy my dual 21" Trinitron computer monitors for years before they both stopped working and got recycled.
The Hi-Def NES looks cool, but the scanlines are not very realistic, IMO, which is a huge part of what made 240p gaming so special (and blocky/no-scanline 240p on an HD screen looks awful, IMO). That said, I've found some excellent shaders recently, like the zfast CRT shaders, which look more realistic (when used with an emulator).