Microwave to Terahertz-Wave Spectroscopy of Transient Metal-Containing Molecules: Hydrides, Hydrosulfides, and Methyl Halide Insertion Products