I do not believe that a comparison between CGA video quality and video game consoles is a very apt one. CGA connected through digital RGBI, perhaps the cleanest signal then in existence. All pre-crash consoles connect through an RF connector, the worst possible video connection available, and it seems to be the default method for the rest of the 1980s consoles. Even the C64 could only do separated video (S-video more or less) at best.
While IBM CGA its snow issue and MDA text is nicer to look at, I would suggest that the MDA monitor's ghosting is a worse issue. This is especially true when it comes to animation. Also, the actual MDA display shows a rather rectangular active display, and shoehorning 320x200 graphics into 720x348 leaves even less display space (320 to 640 pixels) or introduces stretching artifacts (200 to 300 lines).
Sierra's Hercules driver for its SCI0 games show very unsightly text as a result. Similarly when its SCI1.1 games use the SVGA driver, the 200-line backgrounds are stretched to 480 lines, showing similar stretching issues.