I've uploaded a couple of clips I've had sitting around to Vimeo now, and if I compress the original large enough, the quality is pretty good. The Maverick video isn't HD, but that's because I shot it in anamorphic 480p. I didn't have my huge 32 gig P2 card back then (it didn't exist yet, actually).
I tag everything I shoot with the HVX200, and it's pretty sweet if you follow that tag and see there are more cuts with that tag than for cats! You can also see how, with the right lighting and gear, it doesn't look like video at all.
One of the cuts I saw on there demos the Letus 35mm adapter, which is pretty amazing. If you want to really outfit your camera with one of these, you're looking at spending a good $3k once you have a follow focus and matte box, but the images you can get out of the camera are pretty amazing.