On the accuracy of density functional theory in transition metal chemistry