Your question might get better response by posting under
Digital Video topic.
There's also similar thread called
Help needed deciding on a camcorder.
Just to summarize, be more specific about your needs. The trend is high definition, and there are two camps: those hanging onto aging-but-proven-and-mature HDV format (uses MiniDV tapes) and those banking on next-generation-but-still-immature AVCHD (uses memory card, hard disk, or DVD).
For HDV, Canon VIXIA HV30 (about $750) is an overwhelming favorite. It is used by many amateur and semi-pro filmmakers even. You will want to use FireWire for HDV importing.
For AVCHD, two popular SDHC-based offerings are Canon VIXIA HF100 (about $620) and Panasonic HDC-SD9 (about $500). SD9 has received decided lukewarm review for subpar video performance, but it is the cheapest AVCHD camcorder on the market. HF100 received generally excellent reviews for video performance, and is perhaps the best performing and cheapest HD camcorder on the market.
I wouldn't bother with DVD-based AVCHD camcorders. For hard disk, Sony HDR-SR11 ($910) is a popular around here, but it is out of your budget range.
You will use USB for flash memory and hard disk-based AVCHD importing (and for memory card, you can use memory card reader even).
When importing HD footage (HDV and AVCHD) to iMovie, iMovie converts to Apple Intermediate Codec, which takes a lot more space. Final Cut can edit HDV natively, saving space and reducing any transcoding quality degradation.