Metal Gear Solid 2: Sons of Liberty
It boils down to this: You need to play Metal Gear Solid 2.
In addition to being a very good adventure game, it features great writing and beautiful art direction.
Final Fantasy X
If you've been waiting for the definitive role-playing game for the PlayStation 2, here it is.