Maybe not exactly rock music, I think but I'm a sucker for the music of Nico especially "The Marble Index" and "Desertshore".

Both albums are produced by John Cale who is a true rock legend in his own right