Localized versus collective electron behaviour in rare earth cobaltates and semiconductor metal transitions in NbO2 and VO2