Back in 1994 when the movie Stargate was first released, I remember watching it in the theater and liking it much more than most of the reviews at the time suggested.
I watched it again on DVD a couple years ago, and that time I didn't like it as much. The pacing seemed off, the plot a little silly, and I think I couldn't get past a couple inconsistencies with the Stargate SG-1 TV series that I had watched quite a bit of in the preceding years.
I watched it again a couple of days ago, and this time I enjoyed it immensely. The pacing was good, the ideas and universe created were interesting and detailed, and I saw more ideas that were well integrated into the TV series than I saw inconsistencies.
I think maybe it's one of those movies you have to be in the right mood to watch. There are so many cool ideas in it, from a "hidden history" on Earth to traveling to another world. I think I've always appreciated movies like that, but somehow the presentation in this one falls flat for some people. The immense success of the TV series probably demonstrates that well.