You asked

Is the sigma 65mm f 2 dg contemporary good for video?

Here is what the site says about that.

From Sigma 65mm f/2 DG Contemporary: Sigma 65mm f/2 DG Contemporary: A prime lens by Sigma for Full frame cameras, 65mm f/2. Specs - Maker: Sigma - Focal length: 65mm (prime) - Maximum aperture: f/2 - Made for: Full frame sensors - Mounts: Sony E, L-Mount - Stabilised: no - Autofocus: yes What it frames like - On full frame (Sony E, L-Mount): as marked, 65mm. - On APS-C (Sony E, L-Mount): like 98mm on full frame; f/2 gives about the ...

From Video: Video: Almost every camera shoots video now, but the features that make a good video camera aren't the ones on the front of the box.

Quoted from this site's pages.

From these pages