Sony's are great to just get this started. there new XDCAM EX is dropping soon i believe. Which shoots in a true 1080p in multiple formats and frame rates up to 30fps. Now when shooting in 720p mode you can acheive up to 60fps. The camera also uses 3 CMOS processor chips, rather than your pretty standard 3CCD.
Continuing on sony, while HDV may not be around much longer it certainly is as good, and better of a format than SD, and achieves very nearly that sharp HD quality and was standard until the prosumer panasonic AG-HVX200 came along.
The HVX is actually used as more then a B-Roll camera for most film companies that use it, infact Mack Dawg shot primarily onto the P2 form of media provided by this camera. Poor Boyz also uses the HVX as there primary film camera as do multiple other compaines at this point in time. The only realy downsides to the HVX are the fact that when shooting in 1080p, its mearly a stretched 720p image, rather than being true 1080. Another downside is the cost, while for its technology its reasonabally priced, and the fact that the p2 cards have dropped a good amnt in price, P2 cards still rape your wallet. The sony cards are nearly half the price, and if you have a MacBook Pro you can directly insert the cards into your computer without having to run a firewire to your camera! NEATO!
I'm a sony fan, i'm sure it shows. Both are great cameras and both are VERY near the same cost after you get all your accesories to go along for each camera. From what i've read on the Sony, in my mind it has a slight edge.
Facing your biggest fears, and being honest with yourself, and everyone around you makes you stronger and more respected. Stay true, dont hate, show love, and change the world.