Passion is supposed to be the secret sauce that transforms average managers into dynamic leaders. The reality is more complicated, says Jon M. Jachimowicz.