BBC viewers were emotional while watching a documentary showing Sir Chris Hoy's terminal cancer battle.