Leaving aside how that premise merely serves to insert your outside character into the real story of a regional stalemate between three major powers, what's wrong with a good old fashioned revenge plot? Do you think Hamlet and The Count of Monte Cristo are bad stories?

Main Pokemon games usually have a similar story mostly

If you compare it to the first parts of Fallout 3 its a huge letdown. I didn't care for it.

Monster Hunter , or every open world rpg that have a customize character.

Knights of Pen and Paper was pretty good without much of a story, and so was Rainbow Moon

The thing that really got me about FFIV was all the deus ex machina moments near the end. Half the playable characters appeared to commit suicide in order to help Cecil, and yet all of them except Tellah were miraculously rescured. :)

It would honestly be faster to ask which RPGs have good stories.

The Elder Scrolls series as a whole has never been very strong in the main story department. I love the series, but the main narratives are usually merely passable and serve as a skeleton that holds the actual meat of the game together.

Fair point. I sunk about 100 hours into that game...the story just wasn't quite epic though.

But fuck I wish it had done well enough for a sequel.

Probably most recent Bethesda-Open-World-RPGs. Fallout 3, Skyrim.

Main Stories are pretty 'meh' but besides that they are still good RPGs. At least these two are the first I'm thinking of.