Some of the Mon Calamari Cruisers from Star Wars are quite Aesthetically pleasing. Though They don't look as heavily armed as these ships.
Its not perfect, nor does it really look like an effective warship, but it has its own beauty in a way. I guess its just my nostalgia about the old Star...