I bought and played the Stone Prisoner (Shale), Warden’s Keep, and Return To Ostigar DLCs over the weekend, and the equipment from them was great. Definitely skewed the curve on equipment, even though I was late enough in my playthrough that I didn’t get much chance to play around with Shale.
When I got to the Archdemon, I had Alistair wearing full Cailen, and my rogue was using Starfang and Duncan’s Sword as his primary weapons. Didn’t really have much effect on the rest of my main party, but that let me shift some good equipment down to the gate crew. Not that they needed it, since I just had Morrigan constantly casting Storm of the Century at the spot the Darkspawn showed up.