All of the Dragon Quest games come to mind. Super Mario Galaxy was the same. Pretty much every FF game from the PS1 era to today also comes to mind, it's just hard to write an engaging story that can hold your interest for 50+ hours and I feel they all show that.