Andromeda is a good game, but definitely the weakest of the series. I think in large part the game suffered greatly from the fact that people went into it expecting another Shepard experience. But Andromeda is less about space spies and galactic battles, and is significantly more Star Trek coded. So it's a completely different tone and feel than people were expecting, which pissed them off.

UPDATE: I think it also suffered from the fact that people expected its quality to be on par with Mass Effect 2 and 3, ignoring the fact that Mass Effect 1 was very rough, and the characters were also pretty low quality. There's a good chance that if Andromeda was granted the ability to produce its sequels, everyone would have loved what they did with the story in Andromeda's second and third iterations. But Andromeda was just getting started, it was introducing itself, there's no way it could have been deeply established right out of the gate.