Insight into Biological Small-Molecule Activation from Enzymes, Model Complexes, and X-ray Spectroscopy