From deeply personal photographic displays and open studios to group shows exploring themes of memory, the months of June and July are brimming with art exhibitions