i think we are talking about a few different things here... image sharpness, compression of video on vimeo/youtube, compression of video at various stages...
ok sharpness. personally i think a few factors contribute to image sharpness. lens for sure, but the challenge for dslr footage is it is quite difficult to focus properly on a 2.5" LCD screen. that's why people will buy a z-finder or even a HDMI monitor. that said, ONLY 7d has double processor, able to output video via HDMI as HD. all others including 5DM2 has got only 1 processor, so 5Dm2 may be a full frame sensor, and records at full 1080p HD, but HDMI outputs it only as SD, which makes it slightly harder to focus on your HDMI monitor compared to a 7d body. but all in all, trying to pull focus on a 2.5" is hard enough. also, if you're using prime lenses, it's a known fact that virtually all lenses are NOT the sharpest wide open... sweet spot is always a few f-stops up from the smallest... i've got a nikon 50mm 1.4 and even at 1.4, it's not half as sharp as at f2 or f2.8. but then again, that difference is only visible if u blow it up 10x on your lcd screen. on your computer or vimeo, the general public's naked eye can hardly tell the difference.
and if you're shooting indoors, my experience is if you don't have a light source, ur ISO will probably be quite high depending on your lens. so at high ISO your video will have a significant amount of noise and that too, will affect your sharpness. that's why people who make movies always have lights. always. if you're doing event coverage, gotta pray hard for good light source.
so trying to pull focus on a 2.5" lcd screen and noise, IMO, is what mainly affects sharpness. also, certain brands of lens are known to be sharper than others. MOST canon lenses, however, are not as sharp as others... that's why people are buying manual voitglander lens to put onto their GF1 or other m43 bodies for photos/videos. and that's why i have a nikon 50mm 1.4 lens on my 7D.
I'm no expert in compression of video at source or output to vimeo etc, but 1 thing i do have to say is with all the hype about 24p, there is really NO need to record at 24p. the film look is NOT recording video at 24p. it's recording it at whatever frame rate with 2x shutter speed. ie. recording 25p and at 1/50 shutter speed. in fact, if u record it at 24p, and you are going to output it to youtube/vimeo/facebook etc, it's ok as video on the net will play whatever you dumped on it. but IF you output it to dvd, your image quality will all just turn to mush as PAL is actually 25p and going from 24p to 25p, your NLE will have to extrapolite that 1 single extra frame from your 24 frames to make it 25p. and THAT will cause your sharpness to just disappear altogether. believe me, i've tried it. Just shoot in 25p at 1/50 shutter speed. so unless you are wanting to convert your final footage to film to be screen at some film festival where they use actual film (which will cost about 20k to convert from digital to film) and a projector, it does NOT make sense to shoot at 24p.