Why has nobody mentioned wh40k: dark Heresy? Although maybe not 100% space oriented, I bet I could have made a long campaign based inside one of the imperial ships/fleets. you can't have a space opera before you are floating through space in a ship that looks like a cathedral.
The game...