"Funeral for a Friend" is probably the best part of the saga. Some of the individual parts, like the "Metropolis Mailbag" and Pa Kent's death, were emotionally affecting. The actual "Death" story is, as Steve notes, just Punch-Punch-Punch, though seeing Doomsday tear through the Jurgens-era Justice League was pretty surprising. (No, they weren't big guns, but they'd gone toe-to-toe with some of the DC Universe's biggest foes back in the Giffen era.)
I really liked Steel and Superboy.
I genuinely believed, at the time, that we'd reached the end of an era with Superman.