This is a freaking fantastic game, and you shouldn't miss it. Seriously.
The title probably didn't get its due because being an Xbox exclusive in the early days restricted its visibility, and it's licensed fare. And let's be honest, some reviewers hate licensed fare (to be fair, most licensed fare sucks).
Sure, there are some hack-and-slash tropes in the game (a la Baldur's Gate), but this is a pretty game, has great level design, differing feels for each level, fun side quests, and well-done cut scenes (though there are a couple that seem disjoint on the graphical side, but that's only when compared to the others of super high quality).
Actually, the cinematics (I think mostly done by Dragonlight Productions, Inc., who I don't know if is even still around) are high quality, with solid voice work, interesting, cinematic flare, and are head and shoulders above most video game cut scenes.
And the game has prettiest, most subtly effective water I've seen. Last-Gen or Now-Gen. Seriously.
And a game like this, designed to be played together, really shines with 1 to 3 friends questing along.
And there's a whole bunch of "little" stuff this game does well.
Things like the water. Usability things like your most recent saved game moves to the top of your save/load games menu. The game slows down action while you make button assignments, but doesn't stop the action. Your characters change looks (onscreen and in menu) as you swap out armor and weapons. It's easy to buy / sell / drop / give items.
Keep in mind, this was 2003.
You can pick up this game for dirt cheap new or used. I highly recommend it.
Would I rent? Yes.
Would I buy? Oh, yeah!