What video codec is the best balance between quality and file size?

The best one I find is the CoreAVC™ Professional Edition 1.9.5.

You can find it at http://www.coreavc.com/

I use it because it offers great compression for both HD and SD material along with 2k and 4k footage.