Others that I looked at had 1 or more of the feautres missing (like still photo of 640x480 or CCD pixels of 480,000).. so in the end, I found this to be the best priced camcorder for the money ...(Only difference I see in TRV27 is that TRV27 comes with some editing tools... (which I won't use anyways). I also looked at the TRV17 which had everything I wanted expect it's photo resolution was at 640X480.
Video Editing with P-III, 450mhz, 256 mem, Windows XP with firewire port was a breeze. Just install the firewire card and load the drivers.
You transfer still shots via the usb port. Its very easy to do. Just plug in the USB cable (it comes with one) and you will see "Sony Digital Camera" on "My computer" Just drag and drop your photos into a folder.
Although the color and sharpness of this camera is amazing, my only gripe is that the video and stills gets grainy with low light. So I'd suggest you buy a light for the camera if you plan on doing a lot of indoor shots (or at least make sure you have a good light source.)
I also recommend you buy 1) UV filter lens (mostly to protect the camcorder's lens) 2) 32MB or 64MB memory stick (instead of the 8mb it comes with) 3) Wide angle lens 4) carrying case 5) Extra battery (the one it comes with lasts about an hour)
Even if you don't buy this camcorder, after all my research, I would stick with Sony or Panasonic camcorders (they seem to get the best reviews)