A High-Resolution Survey of Molecular Abundances in Transiting Exoplanet Atmospheres