FF IV easily for best story. The entire game was nothing but a classic Shakespeare tragedy.
FF VI a very close second.
FF VII and on is where it started lacking story and traded narrative for flashy graphics and dude bro casual mainstream appeal.
For example, FF VI had a 1+ hour ending sequence and FFVII had all of a 30 second unfulfilling FMV...