As a kid I was heavily impressioned by the alternate timeline Enterprise D

It was able to break the Warp 10 barriar and equiped with a cloaking device.  

I always thought it looked awesome.  Even more than it actually does.  (I saw it when I was maybe 10, and had not seen it again until less than a year ago... surprised to see it actually played a smaller part than I remembered)

Other than that, I think I like Ferengi ships.  They seem the most realistic.

I have a soft spot for 24th century Klingon ships, the command ships in particular, mostly because I built a model of one as a kid.  Romulan ships confuse me.  Their structure doesn't make any sense to me.  I thought Dominion ships (DS9) look pretty awesome too.

To be honest in reply to land, why not go with voyager with slipstream, faster than warp 10?

That is certainly late 24th century design, and certainly post-Voyager.  You can tell based on the position and appearance of the Impulse engines.  Its the same appearance and design as Voyager, which is different from the Federation ships in TNG and DS9; all similar to the galaxy-class enterprise.

I haven't seen much Voyager, but it certainly looks pretty awesome.  I'm going to have to go look into this ship.

I always likeed the Vulcan ships from Enterprise. The burgandy color scheme was a nice contrast from the Enterprise's grey hull, and the "big ring" was a cool design motiff.

The Negh'Var

because it is a very strong ship and looks very impressive

     I built models of nearly every ST ship. My favorite is Voyager. It is clean lean amd mean and it has the ability to land on a planet. But out of all of them they seem to be lacking in the firepower department. All the bad guys get hammers to bash with and the good guys seem to get rubber mallets. I've designed a Mothership for my book called Ta'mara. Essentially it is an ellipse like a gently flattened teardrop. The fantail is flared and there is a single baydoor that can be made totally transparent to outgoing vessels. It can also be made solid should the vessel come under attack. To port and starboard are causeways with 'trundle bugs', actually mobile platforms that ferry starships from their berths to the flight deck. These starships, of which there are thirty, are Raven Class Heavy Cruisers. They boast eight high-intensity Pulsar emitters, four Quantum Pulse cannons, four EM Pulsars, a shielding/cloak that can be manipulated forming images from a dragon to a dust cloud and two state-of-the-art engine types. The smaller of the two is the warp drives. Not the conventional types which limit others to a warp ten capability. These are capable of driving the ships well beyond the theoretical limits. Next are the Slip Drives (these are a take-off on the drives from the ST Voyager series). These engines are capable of propelling the starships through the slipstream and, depending on what currents in the stream are used, can traverse the galaxy in a matter of hours as opposed to weeks or months. What the hell...why should the bad guys have all the fun! Lol

Ships are functional. To ascribe aesthetic qualities to them is not logical.

VOY:4x26; Hope & Fear episode, quantum slipstream drive. Not as polyvalent or advanced (and, technologically functional!) as the Relativity though.