If no pausing is a trade off for finally being able to map more than three of my powers to use in real time on console, it is infinitely worth it. Take the Adept class for example: if you mapped singularity, warp and pull for quick use, every time you wanted to use a throw, shockwave, cluster grenade or your bonus power you were forced to pause the game and use the meny. That was not a satisfying way of using your powers (and everyone were forced to do it if they wanted to use more than three powers), throwing grenades were outright awful using it.
Using powers on the fly with the press of a button >>> using powers by pausing the game, interrupting the action, and scrolling through a meny wheel and pressing A/X.
I'm assuming the power mapping will work in the same way as the power system in Dragon's Dogma, i.e. hold a button to select a second set. Seeing as Dragon's Dogma is the best playing action RPG this side of Dark Souls (especially when it comes to power use) I expect people to be exited for this change, maybe Mass Effect Andromeda will be for power based sci-fi action rpgs what Dragon's Dogma were for power based fantasy action rpgs.
I mean just imagine how much worse Dragon's Dogma would have been if you only could use three powers at a time and the rest was mapped to a meny (There is a reason the warrior was the worst class). I expect that be the case in reverse for Mass Effect Andromeda.
Finally, the pausing in Mass Effect didn't make the game smarter, more challenging or more tactical, if that's what you are looking for in a Mass Effect game you should have played the multiplayer.