Add to the fact that they're connected to a large, underground creature, can't cast magic for some reason, but can mine lyrium and enchant
That's true, I'd forgotten about these details. As a stock fantasy species, dwarves were never pegged as spellcasters (unless it was to infuse magic into the things they crafted), but BioWare went the extra mile by explaining that they flat out can't cast magic, and gave interesting lore reasons for it that we're still uncovering as the story unfolds.
plus there are hints suggesting that at one point or another they've warred with ancient elves and then ancient elves have chased them under the Earth's surface.
Eh, this I find a little less inspired. The whole "they've warred with ancient elves" thing just falls back on that tired old "Elves Verses Dwarves" stock trope, which I'm frankly sick of.
I'd also hesitate to pin elves as the culprit behind dwarves living underground to begin with, because the thing is people don't tend to thrive when forced out of their homes into environments they aren't familiar with. And the underground isn't exact a hospitable environment (even before darkspawn). Yet, when elves were at the height of their power it's implied that dwarves had a vast and luscious underground empire filled with complex tunnel systems that spanned the entire continent. That's pretty sweet.
Also, is it just me, or is it implied that the Titans are "The Stone" that dwarves worship and are connected to, and the titans themselves look like they do better underground than above ground as it is? (Can you imagine those things walking around on the surface?
)