Star Trek just needs a detective adventure game story mode similar to those Sherlock holmes games, mashed with Bridge Commander space combat.
Paramount/CBS are retarded though and have been shitting on the franchise since DS9's final episode, so never going to happen unless fans secretly make it.