The main story, had hit or miss moments. The real problem is the pacing was horrible. You do part of the main story, venture off and do whatever, for some of us that meant a ton of hours in side quests. You get back to the main story again, but it's spread out so far between it loses it's impact - especially if you went into it blind.
This is a much longer game, than the other games of the series. So I feel a longer main story was needed.
Bioware needs to catch on. I feel most Bioware fans play for the story. The game comes second. Usually this is not how it works in gaming. Mass Effect 3 proved to me, that no matter how well a game works mechanics wise or looks. A horrible end to a story can ruin a 300 hour invested experience. No other developer is like that for me.
World of Warcraft's lore is bad in a expansion? That sucks, but there is plenty of other stuff I can do. It is not like that with Bioware games.
Your first play through, you probably miss some things. By the second time you know how to best maximize your experience in regards to story telling. I know when I played Dragon Age 2 I hated it mostly but I finished it. By my second play through (a few months later) I accepted the story for what it was and gave the game a solid 7.
So I hope I do enjoy the story more, now that I have the experience needed and know what to skip. I hope that allows for better pacing. Not sure if that means I will enjoy the story more, but I'll give it a try.
The story itself? As I said hit or miss. For me at times it was fantastic, and at other times it was average - to uneventful. It was rather anti climatic for me overall. I'd say it was just about above average. I got more enjoyment, just talking to my companions and doing missions with them. Compared to anything the main story offered.
I would have liked to see things play out in game, rather than Morrigan being used as a narrator. I think this felt cheapened because for me the ending was average and anti climatic.
The battle was certainly lacking in that area. We round up forces for awhile and what do we get? A handful of soldiers once in a great awhile in between picking up loot. In fact they are easy to miss sometimes. Dragon Age : O right off the bat pretty much gave us a very intense battle, and it felt like it mattered. Dragon Age : I was a big miss there. Why the change with Desire Demons? Why drift away from Dark Fantasy? Why also keep the romance options classy in this game? Trying to appeal to more people? Trying to be more politically correct? Why worry about that when you have homosexual options and a transsexual in the game? Which by the way I fully support and I am proud to say they are in this game.