Limitations of current density functional theories for the description of partial π-bond breaking