I didn’t love 7’s story. There’s a bunch of fluff with every side-character having their own mini-story. The amnesia plot line in particular was annoying.
I generally like the whole lifestream stuff. But I think the whole story is pretty mid compared to the storylines of other Final Fantasy games.