My opinions expressed only through Square Enix games.
Dragon Quest Heroes: The World Tree’s Woe and the Blight Below is an excellent title, it rhymes and it is long as hell and even though I have never played it and don’t play Dragon Quest games generally (except VIII), I will probably remember it longer than I remember the names of the Presidents.
Kingdom Hearts 358/2 Days is bad because nobody can say it correctly without someone telling them ‘it’s Three Five Eight Days over Two’.
Bravely Default II and Kingdom Hearts II are bad because they are the third games in the series. Bravely Second was an okay title before I had to contend with BDII.
Final Fantasy X-2 is good because it uses the Roman and Arabic numerals to convey different things, and I like saying ‘Ten Two’. But I think it gets confusing when you have things like Final Fantasy XIII-2 and then Lighting Returns: Final Fantasy XIII - stick to a naming convention!
Star Ocean: Integrity and Faithlessness is bad because it is meaningless word vomit. But Tactics Ogre: Let Us Cling Together sounds great, it’s wordy but it makes me think about teamwork. And it’s a Queen reference so it is automatically cool.
Kingdom Hearts 0.2: Birth by Sleep – A Fragmentary Passage is just taking the piss.