Waterworld - no question there. And the first Matrix movie (the others were boring). I, Robot was pretty good. The Star Wars and Star Trek movies range from okay to absolute crap.
I'm really really looking forward to The Golden Compass and the rest of the His Dark Materials series. They're being produced in England, so I hope they make it over to theaters here. I almost got the chance to work on them, had an interview with Framestore that sadly didn't go well.
Do fantasy and horror count?
LotR, What Dreams May Come, The Sixth Sense, Harry Potter (all of them)