I just read one that isn't a Stargate cross (at least, not yet), but has some similarities to the one you described. Harry keeps accumulating people, because he (and they) tend to keep needing last-minute escapes before their deaths, and Harry has acquired the ability to create portals for transportation, but setting a destination can sometimes be a problem. I had trouble getting past the first arc, which is a cross with Silent Hill, because I'm really not much into horror, but the story was more to my taste after that.?It's ?by AthanMortis.
As for recommendations, some other SF crosses I've enjoyed are:
- MCU, unfinished.
- MCU, complete.
- MCU, complete.
- MCU, complete.
- MCU. Not marked complete, but the author did a final "wrap things up quickly" chapter.
- MCU, complete.
- Dr. Who, complete.
- MCU, unfinished.
- Mass Effect, unfinished.
- Neon Genesis Evangelion, complete.
- Star Wars, unfinished.
- Star Wars, complete.
- Star Wars, complete.
- Stargate SG-1, unfinished.
- Stargate SG-1, unfinished.
- Stargate SG-1, unfinished.
- Stargate SG-1, unfinished.
- Superman, complete. Has several sequels, also complete.
- X-Men, complete.