I think the story got much better towards the end of the game. The last mission is as thrilling as any of the prior titles. The trouble is that it ends as it’s getting good, and major plot hooks are left forever hanging due to the cancelled DLC.

The setting wasn’t great - there seemed little point for setting it in another galaxy other than being able to ignore a lot of the prior games. This was not Stargate Atlantis. Stargate SG-1 only really had humans and Goa’uld since day one so Atlantis having only the two races in another galaxy fit into the established setting. Mass Effect had a lot of sentient races in the Milky Way, and Andromeda only having two made it feel lacking (especially with some plot revelations).

Gameplay was the highlight as others have touched on. They really managed to refine the combat to the best it has been.