I'm starting to understand what irks me with stargåte.
Typical episode structure:
crisis, side stuff, crisis, crisis, side stuff, crisis, Crisis, CRISIS, fix, end credits.
Most of the time there's a bunch of side stuff that is just left unresolved. Oh, it will probably get mentioned couple episodes later, but still..