He joined rebel convoys in Africa and turned his time with GIs in Afghanistan into an Oscar-nominated film. But his subject wasn’t war – it was people. Ahead of a major show, our writer remembers his former colleague