C–H Bond Functionalization Using Pd- and Au-Supported Catalysts with Mechanistic Insights of the Active Species