Metal Enrichment Leads to Low Atmospheric C/O Ratios in Transiting Giant Exoplanets