Freelancer: Battle for Mankind Galactic Legends is an RPG-based scifi-combat simulator based on the whole Stargate Franchise. You are able to fly every of your favourite spacecrafts from the different series and also some fan-made ships. Fight any enemy which stands between you and your goals!
close-up of underside of Al'kesh showing the
(working!) turret. courtesy of Stargate BFM's
Darkprince