It's a dull 6/10 RPG geared toward novices of the genre/young players (it's not a hidden gem with a proper identity worth a try like Hybrid Heaven).
It's not as terrible as is often maligned.
The two main issues are, first the context upon which it was released since being the first proper RPG on a console starved for RPG, that was the successor of a console with plentitude fo great RPGs, it had a lot of hype behind it just for existing which meant it garned great sales but also was/is subject to a lot of criticism, even beyond its scope (game made by a little developer, geared toward a younger audience so wasn't meant to be deep).
However its second issue is that it is a game visibly unfinished.
You may think "unfinished" as happens with many games for which they are what they are but are filled with bugs and in general lacks polish but no, it's a different kind of "unfinished".
More like the developer spent a lot of time creating the 3D assets (which was complex task back then) but then didn't had enough time to use the assets to fill the game with worthwhile content/quests (there isn't even an economy/money in this game which is absurd for any kind of RPG) and had to hastily use them to somehow ship out a coherent game.
In fact there are character models clearly meant to be main NPCs (or even possible characters controller by the players) that were repurposed as simple NPCs and most of the features talked in interviews by the developer were never implemented.
Compare the different graphic settings of Quest 64 by humbly Imagineer with the one of the uber popular (and deserverly so) Final Fantasy VII by wealthy RPG king Squaresoft:
FFVII was/is an infinitely better RPG than Q64 but the Final Fantasy series had to wait a whole generation and another next-gen console before leaving its 2D roots and landing into full 3D.