Is there a purpose for your camcorder needs? Talking head documentaries? Or something with a bit more motion? Something with not a lot of light? Are you needing a lot of extras, HDMI out WHILE recording, time lapse, fast fps for slow mo in post, high bitrate for a lot of motion, long continuous record times, yada yada yada.......
Tape can be better looking in some situations. Talking heads. Because it is a constant bitrate. But HDV is only 1440x1040 pixels of resolution.
SDHC gives you options in terms of light weight and low power usage. And AVCHD can be 1920x1080 pixels of resolution. But only 24Mbps to store it, or less.
I like my FH1 - 1080p60. But it has it's quirks. Stabilization is pretty horrid unstabilized and at full zoom. But a lot of that can be compensated for with a little forthought and care.
Lot of options, some specialized, others more generally good. HD2000 is good starter cam. Canon's are generally good if you're an indie type. Sony's if you mount your cams to race cars. And other options. The panasonic GH1 is a decent option, but still a bit pricey. Canon 5D mk II or 7D on the higher end of things. Lots of options for various purposes and levels of quality.