^ X-Wing Alliance.
< Nothing beats the emotion and action of that story. I'm not a massive star wars fan, but that game really had a strong emotional story to it. One bit that stood out for me was the scene in the final battle where your fighting amongst the fleet in front of the death star, along all 3 ships that you've served. Then suddenly the one you were on for 3/4 the game gets blown to smithereens.
Also the scene at the medical station when it gets attacked by the Star Destroyer 1/4 the way through, and you have to leave your brother and your father behind to escape being owned by a swarm of fighters.
Finally the most adrenaline filled scene for me when your with a frigate carrying an Imperial informant told to protect it, then a fleet arrives to kill you - just before you get blasted your carrier ship shows up and shields the frigate until it can run. So cool.
V Ever played it?