For an amateur movie-maker like myself, the AG-HMC41 is quite a stretch to buy, but if one can get over the cost, the rewards are well worth it. For the non-technical, it has a full auto mode, so it's 'point and shoot' if you want. But the possibilities, should you look into them, make this a camcorder of use for professional broadcast ENG (electronic news gathering) jobs, with the option of manual control of most functions - zoom, focus and iris. It shoots in HD, with the highest possible (at present) resolution, to 1080 lines, progressive or interlaced, but you can set it to record at lower resolutions - I find 720/25P good for the dramas I make, the 25 full frames per second giving results very close to the 24 fps of film cameras used in professional cinema, and you get more on the SD/HC card which stores your footage. (Using solid-state memory means there's no mechanical transport system to make a noise or wear out, and the camcorder is much lighter, too.)
Other professional touches include a waveform monitor, detailed focus assist (focus is more important for HD than for SD), and an (optional but very desirable) professional microphone adapter for mics requiring phantom power and XLR connections. There's a remote controller by Varizoom which will clamp to a tripod panhandle to control focus, zoom and iris without shaking the camera.
If you want to get the best out of this machine - and why wouldn't you, if you've laid out for it? - you should expect 'professional standard' accessories like microphones and SD/HC Cards and batteries to cost more - I have two Rode wired Microphones which cost around £150 (each), cards of class 6 or better recommended, costing £30-£100 depending on capacity, and a camcorder battery at around £100. I'm considering getting a professional radio mic - Sennheiser EW112P G2 - which will cost upwards of £400.
Transferring footage to a computer for editing is easy - either simply take the SD/HC card out of the camcorder and plug it in an SD/HC slot on your machine, or connect the camcorder by USB 2.0 cable. In either case, the computer sees the shot files as just more data files on an external drive. For editing, you need a program that can handle AVCHD (in other words, BIG files). Pinnacle Studio HD (v.14) will do it on a good PC (quad core CPU, plenty of RAM), or Edius 2.5 Neo Booster, which even works on my dual-core 3GB laptop.
If you're serious about movie-making, this is an excellent machine, and one of the most affordable professional, broadcast-standard ones you can get. Highly recommended.