think of all the attributes that go into good video quality:
sharpness
color
filmer
the HDV format only covers the first one, sharpness, and not even that much. It is not real HD, it only interlaces the picture differently so that there is less fuzz and it looks sharper and has higher resolution. The HDV cams can only shoot 60i anyways.
HDV does not cover motion, such as 24p or 60p or any framerate desired. It does not cover color. for example, the Panasonic DVX100b can get waaay better colors than the Sony FX1, which shoots HDV. And of course a good camera means nothing without a good filmer.
an HD cam doesnt even mean its a good cam. It is debatable, (for reasons unknown) but colors are more important than sharpness. You can buy the sharpest HD or HDV camera on the market, but it doesnt mean shit unless you factor in every control aspect.
Sharpness is only one factor, and HD/HDV is only 1 feature. It wont make your footage incredible by itself.