Try taking a digital photo with a modern single chip digital still camera and scaling it to DV resolution in photoshop. Then compare the resulting image with a frame grab taken with a DV camera. A 3CCD chip is better if the resolution of the sensor is not much greater than the resolution of the intended output medium, otherwise all that matters is the effective size of the chip. If the image from s single sensor camera is good enough for HD, it would be perfect by the time you downsample to DV.
Let me put it this way. The much-praised RED 4K camera is also a single chip camera, and is has no color reproduction problems. Same applies to the Panavision Genesis. These are all high end digital video cameras good enough for Hollywood studios, and they have just one chip. A single large chip with lots of pixels beats 3 tiny chips.
Try getting some HD framegrabs on the Internet, downsampling to DV in photoshop and compare with DV framegrabs. The difference is clear. So you'll probably get better DVD videos from the HD camera. For 320x240px web videos, there is no difference.