Coupled cluster Green's function-Past, Present, and Future