From Giants to Dwarfs: A Comprehensive Observational Study of The Globular Cluster System Mass - Halo Mass Relation