[Josuah]

There are lots of movies that showcase interesting technology. I'd recommend looking at Appleseed, Steamboy, and Final Fantasy VII: Advent Children. Those are ones I can think of off the top of my head.

Beowulf only if you go check it out on 3D, otherwise I'm not sure it would count as anything other than traditional motion capture. Sin City is 100% green screen.

You asked for non-Pixar films, but all the Pixar movies usually feature one or two new technologies in each film, although not blatantly evident, which I think are really cool to try and identify.

Edit: I see you're interesting in things that look real instead of animated. Try Final Fantasy VII: Advent Children. Although it's really worth like 100x more if you actually played Final Fantasy VII yourself.