David Bowie is an album entirely of "cover" songs. That alone makes it one of the best, if not THE best, for "covers".
My two cents on the matter.
And for those thinking of album cover art, definitely Yes albums and anything from Roger Dean. Although S. Peppers Lonely Hearts Club Band is certainly a stand-out classic of album art unto itself.