I haven't played BG3 or Veilguard yet. Both are still too expensive for me.
I have, however, played the first three DA games. I was never that into the tactical nature of the gameplay. I love the story being told and the truth of the mythology that is revealed over the course of the series (like the truth about the elven gods and the archdemons and such).
DAO has a great story that is marred by the fact that you can run back and forth across Ferelden doing all manner of pointless little side quests while the Blight patiently waits for you to unlock its next advancement point. Awakening is
fantastic.
DA2 has a fantastic story marred by the corner-cutting. The repetitive maps and sparsely detailed terrain drove me crazy, but I loved just about everything else about it. Agreed that this game has some of the best storytelling. I loved my sarcastic Hawke. Had to go rogue so I could keep Bethany alive. She's much better than Carver.
DAI has a great story marred by too much grinding. I played as a female elf the first time because I wanted to romance Solas, but I messed it up. After watching the Netflix cartoon, I tried replaying the game as a female
tiefling Qunari mage but just couldn't get far because of all the grinding! Ugh! (This game also suffers from the fact that you can travel back and forth across vast distances while the bad guys patiently wait for you to unlock the next plot advancement point.)
There's so much awesome stuff in the Dragon Age world, but it's the elves and the unfolding story about their past and their gods and whatnot that really captivates me the most. You get the setup in Origins, then you get a few more clues in DA2 if you befriend Merrill, who is trying to repair a broken magic mirror. Then in DAI you get to experience functional magic mirrors and you can explore the magical world that the elves of old created! You also get clues that what the elves believe about their gods isn't the truth. Finally, in Veilguard, the truth is revealed! (I have yet to experience this for myself, but I have read about it. I don't mind spoilers.)