The big highlights are the awesome special effects and set designs, but I also find the world-building and imaginative genre-mashing (science fiction + action + biblical epic = Stargate) just as compelling.
Plus I love the off-kilter chemistry between James Spader and Kurt Russell.
I can't help but smile when Kurt Russell utters "Give my regards to King Tut asshole!!"
It's a shame Roland Emmerich never returned to the Stargate universe, this film was supposed to be the first in a planned trilogy but Emmerich abandoned it in favor of making "Independence Day", but at least we got the long-running TV show.
... I still do.