There are a lot of really great spaceship designs out there, and being the Trekkie that I am, the Enterprise is always going to have a special place in my heart, and since I came to Trek with The Next Generation, it's the D that is the one I think of first.
I mean, really, look at that! The flagship of the Federation! Big, beautiful, powerful, with sleek lines and cool colors.
Yet... it's intimidating. That's the ship of Captain Picard!
If I ever get the chance to play in a Star Trek RPG, I don't want to serve on a Galaxy Class Starship like the Enterprise. It's too much. It'd be like starting a D&D game with a +5 Holy Avenger.
I want something a little less overwhelming, and Rick Sternback provided just the ship in Star Trek Voyager. Not the Intrepid Class Voyager herself, but the Equinox. A Nova Class science/scout ship.
It only has a crew of about 80, is designed to hit warp 8, and is equipped with a wide variety of sensors and a special shuttle docked on the ventral side of the primary hull that is designed for atmosphere operations.
It's also the only non-Enterprise model I've bought. There's just something charming about it.