Agreed re: the characters and story. It also helps that Inquisition has some returning characters you already have attachments to, but even the new characters were very strong; I can't think of anyone in the main cast that people didn't like, except maybe Sera (for understandable reasons, though she and I got along fine).
Perhaps the biggest red flag about Andromeda for me should've been that every time a dialogue wheel came up, I didn't want to engage with it. I didn't want to go through all of the expository branches to learn more about the situation, like I did in every other Mass Effect game up to then. I didn't care about whatever new mission I was on that took me to some new world with new problems I couldn't get invested in. I was just kind of... done with all of it. I still don't know if that was Mass Effect/Bioware fatigue, or if the game was genuinely just not very good, but I really don't remember forming attachments to anyone in my crew, and found them all either bland or insufferable to some degree (Peebee, ugh).