Explosion imminent: the appearance of red supergiants at the point of core-collapse