ME1's ending was awesome. ME2's ending was good (suicide mission was great, until you get to the Terminator wannabe; then it destroys all suspension of disbelief and becomes a comedy). ME3 had the worst last mission possible (London), with horrible ending(s) (and it doesn't matter if you'd happen to headcannon that the ending stopped at the Anderson death scene, you still have to admit the disappointment that was London prior to going inside the Citadel).
With the Dragon Age franchise, it's a mixed bag. The ending(s) for Origins were good, generally-speaking. Then they just had a brain fart with DA2. Then with Inquisition (vanilla) it was extremely bland, and underwhelming, with what ended up being one of the weakest (in my opinion, the weakest) villain BioWare ever created (Cory was alright up to Heaven; after which he became too distant and a negligible threat, with your Inquisition having victories left and right, up and down without having to go through any major hardship or losses). Then Tresspasser came out and pretty much repeated the underwhelming feeling of vanilla Inquisition's ending (get to Solas, - not before a disappointing "last fight," of course - have a conversation with him, and that was... it; incredible climax there BioWare)... albeit it did answer a crap load of questions, and had a pretty decent epilogue to explain what happened next to specific characters, which is always good to have.
Now, the thing is Andromeda had a new lead writer. So who knows what's going to happen. Maybe it'll be your 'usual BioWare' game; I.E. having overall great voice acting (fitting for each characters), memorable charactes, along with good chacacter-specific stories (or anything regarding their loyalty missions), with a "meh" main story arc, although it may have a good 'final mission' (prior to, or right after you get to bang your LI of course... since the ending is possibly near; so it's time to have some fun, BioWare game oblige), followed by a very underwhelming and anti climactic actual ending, without any epilogue whatsoever. That, OR... it's going to end up being the best action RPG ever created since Witcher 3, and we'll praise our new BioWare Overlords for the next four or five years until they release Andromeda 2 (or their new IP).
My gut feeling tells me: 1) It'll have superb characters (and great stories specific to each of them), 2) It'll have great voice acting. 3) It's going to be very cinematic, and well edited (ME2-style), 3) The multiplayer will be amazing, with much more customization. 4) But the general main story arc will be "okay" at best (I'm voting on "meh"), and there's going to be hardly any really tough decisions to make with profound consequences to deal with (if they're truly not planning for a new trilogy, there'd be no reasons for us to have to take decisions that would have great impact for any future titles that would be direct sequels to Andromeda).
To be frank, I don't actually expect a good main story arc, nor a good ending. What I DO expect is what I know BioWare can and usually DO deliver something like 90% of the time, which are: good, fun and memorable characters, good voice acting (at least generally-speaking), most likely good loyalty missions (going along with character-specific stories, which I'm pretty sure will be good) and a good multiplayer (well, it'll be good, even awesome in my book, if they stick to the ME3 formula and don't change it too much).