Text this: Performance of wave function and Green's function methods for non-equilibrium many-body dynamics