Metal Gear Solid 2 and 3 (and go back and play 1 first, if you haven’t).

Only other thing that comes to mind is FFX. Just try to resist min/maxing too much. Very unsatisfying to spend tons of hours grinding your characters into unstoppable gods and then go one-shot the final boss.