Well, hundreds of billions of people who would have died didn't die. I figure that has to count for something.
Just looking at the scale. When you're measuring what you're saving in planets and galaxies, what is a "small scale" story anymore?
"One life lost is a tragedy. 1,000 lives lost is a statistic."
Stalin.
Absolute jerk and power-hungry maniac, but he knew the human condition. We get caught up in scales and what is important or what is not, and it's easy for us gamers to think less on the impact of our protagonists in the lives of those fictional characters saved and more on "well this game didn't let me save the whole galaxy so why should I think it's as good as the one that did?"
I'm less concerned with the scale of what is or is not accomplished and more concerned with literary unity, cohesiveness of story and lore, the characters and finally how much fun I'll have with the gameplay.
For example, I don't play Kingdoms of Amalur or Dragon's Dogma because I love the story, those games I play because I love the seamless and immsersive combat, and I play the Mass Effect games and the Dragon Age games because it's easy to immerse yourself in the world and roleplay within the context of the story and the wonderful cast of characters.
If something is done well, people will buy and play it for that reason. If Andromeda shines on its own merits and doesn't need the original trilogy to hold its hand, people will buy it and play it, both long-time fans and new gamers.