Sorry guys, there's no free lunch with small sensor cameras for macro videography. If you use a small sensor camera, you get a wider depth of field at a given focal length and fstop, but you loose high ISO performance. And you can take the exact same picture with a large sensor camera simply by increasing the fstop. Either way, you'll need lots of light to compensate for the tight aperture required to obtain a workable depth of field.
I'm assuming regular cinematography lighting techniques can be applied to this. I've also seen macro studio setups with miniature versions of lighting. Do you have any insight on lighting for macro?