FFVII hit massive popularity by being the right game at the right time. And it's a great game, and one of the better FF games! But it was a bit of an experimental bridge between 2D and 3D RPGs.
Final Fantasy VI and Final Fantasy X are much better in terms of gameplay and storytelling.