I once wanted a game for Stargate Universe, that would work very similar to have the TV show set everything out, basically the game would mostly play in first-person or third-person, except when using the ship's Mainframe display, which would Show the ship similar to have this shows up within certain damaged areas and unlocking those areas and fixing them to improve the ships capabilities.
In that show they have the unique opportunity to use Stargates, as one of them was on board the destiny already, and every single planet within its predetermined path.
And as the crew of this ship, it was your responsibility to stay alive, the ship would provide information of what the ship needed in order to sustain the life that was on board it, it would drop out of FTL and dialogue nearby planet where on this planet there were resources that we're needed on board the ship, the ship would create a timer two when the FTL Drive was ready to jump again, and because it was an automated ship at this point, you had to get your resources back in time before the ship jumps into FTL, when you get back using the gate on that planet, you can then take your resources that you collected on that planet and put them to work on board the ship where are the systems needed it.
Throughout your time on board this ship, you are to unlock secrets about the ship and its mission, keep the ship in good repair as much as possible, because the ship will frequently get attacked by other ships and it has been for millions of years as it was automated, but the ship is near its last leg, so it's up to the human crew to fix up this ship the best I can so that they could be ready for another attack, the ship will automatically turn on its Shields when it's about to be attacked by another ship, and it will turn on its defenses.
As the crew you'll run into these events by a certain chance Gap, whether it be on board the Destiny or offworld on some other planet that you're getting the resources on, as commander of the ship you are tasked to make sure the ship works like a well-oiled machine, which means you need to order the crew to do certain things on board the ship at all times.
You will need somebody who can become an expert at Hydroponics to make sure there is plenty of medicine and food on board the ship for the crew, you'll need somebody that is willing to learn the ancient language and decipher certain aspects of the ship to see if they can unlock them, to uncover the mysteries of the ship, you will need somebody who is a doctor and make sure they have the provisions they need in order to take care of people on board the ship, you will need your guards to rotate their shifts just in case something happens while the commander is sleeping.
Basically how the game would work, is most of the planets will be procedurally generated, except for maybe the resources that you need on them, the ship battles will be procedurally-generated based off of level and experience and capability of the crew and a chance gap, every time you and your team gate to a planet it should be at least four people of at least two soldiers one scientist and one Tech person in case something goes wrong at the gate, the Planet will also have procedurally-generated events such as the team possibly being attacked by an alien or an animal on the planet while they search for resources, maybe even use the animal as food for the crew or maybe find medicinal aspects off of the animal for the doctor to use.
If the crew needs help or information, they could either contact somebody via the communication stones, or use the ancient repository chair and unlocked the knowledge using that.
This type of game will never be made, but one could hope.