A "painfully beautiful and unlovely" exhibition exploring the human experience of illness, disease and ultimately death is opening at UNSW Galleries.