Yeah, i would say that any game is good. You will find yourself learning a lot of useless terms though.. well.. i mean a lot of terms without much real-life use. However, this is how i learned most of my kanji outside of anything i learned in class. So for that it works great.
That being said, i would recommend older games if you are less advanced. Like a remake of the 1st final fantasy etc. I found that the newer games have a lot more text and can be a lot harder to understand. So i would suggest getting your hands on Dragon Quest remakes and such. However, the advantage with newer games is a lot of them are voiced with subtitles, so you can improve your listening, and if you have a good ear and memory, you will not be spending as much time looking up pronunciations etc..