Just off the top of my head, the game titles that stick in my mind are single word titles. Doom, Quake, Portal, Myst, Halo, Centipede, and titles that sound like two words but are glommed as one, GoldenEye, Battlezone, HyperBowl (that last one is mine but it's licensed IP so I didn't pick the title). That probably doesn't make sense for visual novels, though.
Viewing post in Show me Your Game Titles
Yeah, good single word titles are some of the best ones (I'm also thinking Oblivion and Rampage). I think these are getting rarer now- mainly because all the good dictionary words are taken.
Goldeneye has got me thinking of James Bond films- and how these really are a masterclass in giving memorable and evocative names to themes that have been done to death. I still don't know how they got away with Octopussy though...