OK...if you are talking how the end result finally gets to your house...then it depends. You and I have seen those hugely expensive sports games that are shot and broadcasted in HD...that would look great on an HDTV if you had digital HD cable...look like crap on a small 13" TV that gets horrid over-the-air reception in the local bar. In that case, you'd be fine shooting with a Fisher Price cassette camera.
Pixels...more pixels make it better. Well...and lens. The lens is really the most important part of a camera. So a DVX-100a might be better than a consumer level AVCHD camera due to the lens...but DVX-100a vs HMC-150...similar lens. So the larger pixels will win, and slightly better compression. DV compression is icky...you can see those horizontal lines on curved objects. But then it has a 4:1:1 color space vs 4:2:0 of AVCHD and HDV and XDCAM.
BUT...this all REALLY comes down to the talent of the camera operator. Give me a RED camera and ask me to shoot something, and give a Hollywood Cinematographer a DVX-100a and have him shoot something, I have NO DOUBT that his stuff will look better than mine. Mine might be sharper...might be...but his image will be far better.
And true, story is king, but assuming that you have a good story, what is the better camera to shoot that with?
Shane
