Here is a link to an older article on this topic, however, IMO today's CMOS is on par with the CCD.
CMOS vs. CCD: Changing Technology to Suit HDTV Broadcast
CCD vs. CMOS
As far as color goes, its difficult to say. It depends on monitor, color calibration & personal preference. Obtain a sample video somehow (google it maybe) and see it for your self.
HD Video is much better when it comes to the picture, maybe you should give your sister your camcorder and get something new for your self
? Majority of consumer camcorder makers made the switch to CMOS, its going to be hard to find 3CCD cam cheap right now, try online.
Going back to DV camcorders, if you use it casually, it will last you for a long time. And as I said, DV tapes are very cost effective back-up solution. I have two 1TB Hard Drives in Array on my system just for video and will need to double that soon. 1 Hr of HD Video = 8GB.
I agree with Papa Deuce - Solid State Hard Drive is the best choice in camcorder, low power consumption and no movable parts. But Id like to see a build in HD, something over 100 GB in size. While I like flash cards, they get lost or mishandled, ending up unreadable.
As far as transferring Video to the PC, in most cases you just cant stick the card in PC and copy the files. Sony does write something in the first file (at least my cam does it). wthout their file transfer utility, the first file is a dud.
Canon on the other hand, formatted their SD cards in FAT limiting the file size to 2or 4 GB (dont remember), when recording non stop for longer time, it forced the camcorder to create second video file. Without the file transfer utility again, just by copying the files from the SD card and joining it together for continues play again, there was a very noticeable video glitch on the join mark. Maybe its fixed by now.
So in a way, youre forced to use USB or FireWire in consumer camcorders using flash media.
Editing??? Since AVCHD video was designed with consumers in mind, not to be edited, youll still need a Higher End PC with decent power to do some editing
Its a $$$ experience to move to the HD video
.