He definitely looks majorly different when in a scene with the Detailed Facial Textures. Tidus was always one of my favorites though, probably because FFX was my first Final Fantasy, and also because I can relate to his personality in some ways.
The Amazon page has some screenshots and a video up showing the facial texture changes mainly... Tidus looks kinda weird with the new face IMO, Lulu's looks nice though.