Magnetic properties of transition metal dimers probed by inelastic neutron scattering