One of the most exciting things I've gotten to do at Cryptic was contribute to the design/development process of Star Trek Online's incarnation of the Enterprise, the U.S.S. Enterprise F.
The design was based on the contest winning entry by ~Ihlecreations
Here's Adam's entry:
Our project's art lead made some rough 3D renders based on Adam's drawing, and then I explored some ideas in this paintover, including how the curve of the necks integrate into the saucer and how the dual neck motif flows from the front to the back of the ship.
The design was taken to completion by our then-ship artist, Adam Williams.
You can see more about that process, including a lot of WIP sketches, here: [link]