Excited electronic states of transition-metal dimers and the VBCI model: an overview