First let's correct the Amazon description, this is a 40X optical zoom camera, not 25X as seen on the product itself.
This is a great camera to start out with, the simplicity of Mini DV tapes makes this a good value choice. DVD camcorders in this price range suffer from bad battery life, and disk errors that can render your disks useless. The Mini DV tapes are tried and true.
I use an Apple computer at home and the camera connects to iMovie with no problems using the iLink port on the camera. All you need in most cases is a Firewire 6pin to 4pin cable, and you are good to go.
The video and audio quality are good, and the night vision is fun too. This is not a upper level camera so don't expect several bells and whistles, but it performs great, and has the basic features most people will ever need. The battery life is fair, but that is expected, all camcorder companies want you to buy an extra battery, but at least Sony gives you several options.
With a full charge and a new tape, expect about an hour of record time.