Another famous album about a woman is Bob Dylan's Blood on the Tracks, supposedly about the breakup of his marriage with Sara Dylan (mother of Jakob Dylan of the Wallflowers). Lots of classic songs about lost love.
http://en.wikipedia.org/wiki/Blood_on_the_tracks
He also wrote Sad Eyed Lady of the Lowlands about her.