The Death and Return of Superman. It's the story line that got me into comics. I still remember getting excited each week when the next book in the storyline came out. All Star Superman is a close second.
But if you count Vertigo as part of DC, then my answer is Sandman.