Baldur's Gate writer says the RPG's cast was "a bunch of cardboard cutouts" compared to Final Fantasy 7's, and the JRPG drove BioWare to step it up | GamesRadar+
In most cases i think, a good character cast is even more important than a good story. I want to like, want to hate a character in a game. That drives me more than a solid told story. And yes, Final Fantasy 7 has done a very good job. Even among jrpg's or among Final Fantasy game, the characters of Final Fantasy 7 in my opinion, had a bigger impact that a lot other characters from games. Tifa and Cloud are charcters that even people that doesn't have anything to do with Final Fantasy often know. Their fanart scene will never die. Final Fantasy 9, X was a good game as well, but i think Zidane and Tidus impact was not as big as Cloud's impact. (My fav is still Yuffie, you don't need to understand that)
Tifa being the childhood friend and remaining by Cloud's side, while being equally soft and tough, is what sold me. I'm also a sucker for brunettes. I remember not caring too much about Aerith but the remake has completely changed my mind and I absolutely adore her. Yuffie on the other hand, bleh. To me she's just an annoying kid. I did like her in Advent Children though.