I couldn't care less for comics, but your post actually peeked my interest to read "The death of Superman".
Wow...I take that as a great compliment.
If you're interesting in taking the plunge, even if only to read "The Death of Superman," here are some options:
Death of Superman
, Funeral for a Friend
, The Return of Superman
There is a hardcover collection, but it makes too many cuts from the essential "Funeral for a Friend," which actually makes you care about Superman's death, and is not up to the quality of the trade paperbacks.
You'll find some of this stuff is dated, but there's still a great story there and tons of heart and fun.
Let us know if you decide to read them!