This is excellent. Most of the answers here are what game to play, in other words, what mechanics can be used to force the horror feeling. This is purely about narrative, which can apply to any system. Thank you for sharing.

That paperclip looks about as handmade as the map!

Convoy escort is a good one. It’s the sci-fi equivalent of caravan guard of fantasy trope fame.

I saw a Star Trek RPG sourcebook that focuses on a not Starfleet campaign. Hell if I can remember what it was called or who made it though.

Putting aside game system and mechanics, I enjoy Traveller, Numenera, and Shadowrun, sure. But none of those can compete with Star Wars as a sci-fi setting.

Edit: Honorable mention to Star Trek.

Looks cool and I like the art style. I would host an adventure in this.

Yes, I agree. As far as I can tell, these are compiled by an actual human, Darryl Mott, and the quality shows.

Thank you for pursuing making the community. I am willing to talk about Traveller and other sci-fi themed topics.