I can't agree with this. I think all the snes and PSone era games told excellent stories that kept you constantly engaged throughout and really went deep on all the themes they wanted to get across. You also knew exactly where you were up to in the story and understood the world and setting without needing any background reading, unlike some modern iterations. Yes they had a few issues in a jrpg sort of way and were a bit wacky in places - but many stories are. It's part of their charm anyway. I agree the nes era wasn't anything special.
As the SNES run goes, I'd say the main pitfall tended to be scope. Possibly leaning on the example set by Link to the Past, every single one of them tried to staple on extra worlds. But in 4 the underworld is only a few spots of note and the moon is just a desolate nothing space). 5 has a bit more meat to the 2nd and 3rd worlds, but there's still a definite fading off as you go on. 6 again, probably benefits from being the tightest of the batch (and also only has 1 additional world).
The PS entries just seem massively unfocused, and too bent on trying to throw twists in. The opening act of 7 is one I will commend. Then suddenly it drops almost all its built up narrative to go chasing Sephiroth. Then it turns out Sephiroth wasn't actually Sephiroth, Cloud is Cloud, but all his backstory is actually Zack. Which considering the rivalry between Cloud and Sephiroth was the main axel of the hero's motivations to chase him, basically unravels about half the proceeding plot of the game. 8 spends its time juggling two separate storylines, then abandons one two thirds of the way through. Then also unloads twist after twist after twist, form the heroes all being amnesiac childhood buddies, to Cid and Edea being their forster parents, to the actual villain being in the future and time-warp-min-controlling the established villains (not that the sorceresses got much character, but they were at least present). Rounding out the trilogy, 9 also shoves some obligatory twists in, but Zidane's origin doesn't really disrupt the backstory, and Garnet's fits in. Most of what I'd critcize in 9 is there's a bit of padding when you're trying to get into Terra that feels forced in there to be a nod to FF1.
and understood the world and setting without needing any background reading,
To take 7:
-How did an electric company end up being the world government?
-Why is there no transit system between these obviously interconnected Shinra locations? That or why are our heroes incapable of using it and instead go galavanting aroudn the world in the most roundabout way possible.
-To add to that, the "LAs Vegas" esque locale is in a remote location, miles and miles, and across an ocean from the only people who would be able to afford to go there (The remake actually makes this goofier, because Jessie who lives in Mdigar but her parents think she's working there)
-Why are there no other cities?. I've already actually forgotten since January if there were reactors outside of Mdigar other then Nibelheim. If the other populated zones don't use Mako, how are they under Shinra's thumb.
-For that matter, Midgar doesn't maintain a port, despite having ample coastal space. They have to trek any overseas traffic down past a mountain range to Junon. Then the only port on the other continent they control is a resort town. Why in hell do they have a massively fortified cannon base as one port, and literally nothing on the other side that is closer to their established enemies.
-What are Summons supposed to be anyways. 4, 6, 8, 9, 10 all bothered to explain this, in 7 they're just kind of there.
-Why did Shinra stop hunting Cloud again? They send a literal army to capture the two dudes. They only killed one. The same could be said for all the Sephiroth clones.
--How are the Turks able to stand toe to toe wiht Soldiers, and superhumans etc. There's no indication they got any sort of experimental upgrades to them. Or why they seem to run only vaguely under any actual Shinra supervision.
-Where do all those Sephiroth clones keep getting his signature sword from anyways (even handwaving that you essentially need Crisis Core and some amoutn of fanwank to explain the clones turning into actual Sephiroth doppelgangers)