A new exhibition in Sandton captures the creative range of the celebrated photographer. It’s an archive of memory, emotion and experience