The Apollo Lunar Lander. The only real space ship we ever built. (I guess we built another one for the next trip now, though, so I'll go with "ever flown")
People can say it's ugly all they want, but, as an engineer, it's exquisitely designed for its purpose. That's true beauty to me.
Mistake Not My Current State Of Joshing Gentle Peevishness For The Awesome And Terrible Majesty Of The Towering Seas Of Ire That Are Themselves The Mere Milquetoast Shallows Fringing My Vast Oceans Of Wrath
Not sure in what context you're asking this question, but my answer is the International Space Station. I love how it's possible to see it at random sometimes at night, and the way it crosses the sky just looks different compared to a regular airplane flying at night.
The Kestrel Cruiser from FTL. Even though it's not even the coolest ship in the game, The Kestrel is still the most nostalgic for me.
It brings me back to when I first played FTL a decade ago. I was a kid back then and loved the game so much, I even built and painted a cardboard Kestrel model.
Enterprise refit. Loved the original Enterprise and the Enterprise D when TNG came out, but there was something magical about seeing the refit on the big screen.
GW: Visually, which is your favorite episode of Atlantis so far?
MB: “The Eye.” The Rainmaker team created their own CG software to create the stormy water for the ocean. The level of detail and control has never been seen in TV effects before. Dan and Jose at Rainmaker pulled out all the stops and created mind-blowing shots. I think we went about 3.5 times over budget on that one — but you can’t get away with crap. You guys can spot that a mile away, and nothing kills a show quicker than cheap looking effects.
The Hail Mary currently. Just such a cool ship from a fun book. To think about what would go into building it and what that means to humanity is humbling.
Other notables:
Enterprise E from First Contact because it looks cool.
Cygnus from The Black Hole
Sulaco from Aliens
Trimaxion Drone Ship from Flight of the Navigator
The Abominator-class Offensive Unit Falling Outside the Normal Moral Constraints (my usual favourite lol)
While I know it's easy to hate on everything MCU these days, I do still absolutely love the Milano from Guardians of the Galaxy 1 and 2. The design doesn't feel practical at all, but it's still a really fun to look at and agile ship, which is something a lot of sci fi doesn't really depict very well.
There's a lot of ships I like in sci-fi, but the one that comes to mind at the moment is the garfish-class cruiser in robotech
Or if we're talking about real spacecraft here, I like the soyuz (and really the whole r-7 derived rocket family to be honest), as I like the look of it's side boosters and the four engine bells on each engine
The one from The Fountain was kinda similar. It was unique enough to stick with me over the years anyway.
I don't know if Ringworld really counts as a ship but I loved that too. The Out Of Band 2 from A Fire Upon The Deep seemed like it would be pretty baddass. Or the alien ship from Rendezvous with Rama.
“I’ll take the Lewis and Clark to a safe distance, and then I will launch TAC missiles at the Event Horizon until I'm satisfied she's vaporized. Fuck this ship!”
It's a fast ship that can flown solo, but also comfortably carry six people with their own quarters. It's fast, can cloak itself and defend itself from anything it can't outrun or hide from.
I don't want a big starship that needs a big crew to fly. But, I don't want a small ship that can't carry guests.
Rebel Blockade Runner, mostly because it's the first ship you really see in A New Hope and my first interaction with the Star Wars franchise as a kid in the early 90s.
The wedge ships belonging to the Chitzas in the books from the "quantum series" by Douglas Phillips. they were bad ass ships ran by badass little porcupine dudes. They were able to travel beyond the visible universe in hours. The books were so much fun.