Final Fantasy XII is the best I've played, with Metal Gear Solid 3 being somewhere around there as well.

MGS1 is pretty notable for having so much voice acting at the time, in a title that was still game-heavy. It was also pretty great for being so pulpy.