I stand by FFX-2 but that’s the only one I’ve played that made me genuinely disappointed.
I also play a game called Hyrule Warriors (definitive edition) and the storyline is incredibly silly I don’t hate it or anything it’s just pretty basic but that kind of game really isn’t centred around story and it does make sense!