I liked the Leonov, as well as the Discovery and the ship in Avatar. And the Enterprise, the real one, from Star Trek, still counts as the most innovative attack on phallic symbolism and pointless streamlining that still incorporates a saucer motif. Babylon 5's Earth warships almost make it for the rotating midsection but the weird armaments cause too much cognitivie dissonance.
All the rest may be pleasing or not to the eye, but there's nothing beneath the surface. And therefore don't really belong on an all time list, I think.