Standard res RGB monitors are not as crisp as PC monitors. But they are still quite nice and really do let the individual pixels shine through.
Most retro gamers now typically hook up their consoles via SCART to a CRT that accepts pure RGB, typically a Sony PVM. I've got all my consoles and my arcade boards running on a PVM and can really easily see the pixels making up the art.
here's a few examples I grabbed off the web: http://imgur.com/a/GXHyf They look even better in person.
Yeah most emulators provide filters that give you scan lines and all that jazz (none of them look quite right). And of course an RGB monitor does not look at all like an old game running in a modern emulator with no filters. But I would still definitely say you can see and appreciate each individual pixel.