Coupled cluster Green's function: Past, present, and future