From Halo, my favorite ship is probably the Heart of Midlothian, followed by the Spirit of Fire. There’s something I like about the slabbed, angular bow.
From Mass Effect, the Tempest, bar none the most attractive ship I think I’ve ever laid eyes on. I think she looks better when you can walk around her, it’s hard to get a good angle on.
And an odd one out, the Taiidan Destroyers from Homeworld are particularly badass, even if their gun layout is objectively hot garbage. Could say the same about most Taiidan ships, they look less functional and more like the product of an unchallenged imperial navy. Kushan vessels feel comfortably realistic but aren’t visually distinct.