Name an artist that had a great debut album and a great final album

I agree with Eva Cassidy. Her first two disks including my favorite - Live at Blues Alley - were released before her death at the end of 1996. Some of her most recent posthumous discs have not been so great.

I would also suggest Leonard Cohen.