I don’t think we’re going to actually get another Mass Effect game, to be honest. Hell, I’ll be shocked if we even get Dreadwolf at the rate things are going with them.
You're thinking of Cora, and if you'd played the game you'd realize that getting over her Asari worship is actually her character arc. She always idolized people who were in command because she felt they had something she didn't, only after realizing her idol is actually a huge POS did she understand that her only obstacle was her own reliance on someone else making the decisions.
She's actually a pretty solid character, definitely more interesting than Miranda's "boo hoo everyone expects too much cause I'm hot and excellent at my job" by a country mile.
Kosta I could leave or take, he's kind of an asshole in the "I think I'm more moral than you and going to tell you how to live your life" kinda way. Though his loyalty mission is pretty funny with all the movie references.
I literally played Andromeda twice, I personally think it's probably the worst ME, but still a pretty decent game. It's literally been years, I don't remember nearly as much about this particular installment than the previous trilogy, didn't leave me as strong of an impression. I made an attempt at a joke. A common running gag when the game came out was to constantly casually mention Asari commandos, at least with the communities I interacted with.
Miranda IMHO gets more interesting with her ME2 loyalty mission and the time in ME3. The rest is indeed kind of bland.