Vector boson production at colliders: A theoretical reappraisal