FF7 is a great game. It's my favorite of the FF series, but it was also my first FF game. That's probably why I like it so much. It's a long way from being the game that holds the title of "Best RPG" on my list, though.
For me, Chrono Trigger is the best RPG ever made, and I don't think any game will ever remove it from that throne. I love everything about that game. It has a great story, awesome music, and graphics that look good even today. Not everyone has the same opinion of that game as I do, though, and that's cool. Everyone has their own favorites.
Back on the topic of the FF games, FF9 is a good game as well. It definitely has some memorable moments, and one of my favorite pieces of music out of the entire series (You're Not Alone). While I definitely don't see FF9 as the best of the bunch, it's far from the worst.
Everyone has very different opinions on this. For me I liked IX but it just wasn't memorable, there was something lacking in it for me so as a whole I didn't love it but thought it was alright. I didn't care for the art style all that much either. FF VII though probably has the worst art style out of all of them but it is my favorite of all the FF games. As for X I absolutely detest that game, I hate all the characters and story and felt it was the worst game in the entire series. The only thing I did like about X was the battle system and how you leveled up and the grid system, I liked that. I liked the art style too but that was it