USS Stellar Drift - An homage to a ship I used to roleplay back in the day. It was originally a joke, as I needed to name a small science ship and all I could think of were silly names. Originally, the science ship was very slow-moving, hence the name. Now, it's the featured ship in my fanfic series and a name that I hold dear along with ships like the Enterprise, Defiant and Voyager.
USS Gambier Bay - Named in honor of another American escort carrier that fought valiantly with Taffy 3 at the Battle off Samar in World War II.
USS Audacious - I needed a name for a starter ship, and couldn't think of anything, but wanted something good. So, I went through a British ship registry, because the British are good at naming ships and found this one. The name fits.
The U.S.S. Sedna, a Luna-class vessel, sort of follows the tradition of naming the ship after a moon, though in this case it refers to the trans-neptunian small planetoid Sedna. There are, after all, so many moons in the Sol system before running out or finding another PC ship named the same (I really wanted Oberon or Titania at first, since I'm into faerie stories, but I was concerned that they'd be far more common names to come across) - Sedna seemed an acceptable enough compromise.
The planetoid's ID number, 90377, is at the root of my science vessel's NCC registry - had STO allowed us to gain access to numbers at the 90 000 limit instead of 91 000, I could've made it an exact match. The planetoid Sedna itself was also named after the Inuit goddess Sedna, so, my ship's name has a double meaning too!
Since my character is Betazoid, I thought of naming my ship after one of Betazed's three moons... but they weren't very appealing. I also did not think it made much sense for my captain to be assigned to a ship coincidentally named after a moon of her home planet/system.
USS Celilo - Named for the Celilo Falls Dam on the Columbia River just east of The Dalles.
USS Watchtower - Named for the legendary homebase of the Justice League
USS Fremont - Named for the Fremont Bridge in Portland, OR.
IKS maQ'legh - the word maQ'legh means "Dark Omen" (although it should be noted I have found several spellings for this word)