The one I keep coming back to is "Pillar of Autumn" from Halo 1. Something about that name is just perfection.
But the new fast-upcoming contender is "Weeping Somnambulist" from The Expanse.
@starkatt Torquemada's Monkey Wrench was the name of a ship in a SW tabletop game I was in once, and it's always stuck in my head.
@starkatt I'm kinda fond of Hot Needle Of Inquiry, or Lying Bastard, both from Niven's Ringworld series. :-)