Transition Metal Complexes for Challenging Reductive Transformations: From Nitrogen Fixation Catalysts to Photoreductants