The writer, curator and editor organised the influential Pictures exhibition and championed artist activism during the Aids crisis