I just downloaded and finished RtO on Sereda (level 19 dwarf warrior, 2H), and I'm... disappointed. Well, maybe underwhelmed is a better phrase. Cailan's Shield was terrible when compared to Duncan's Shield (T6 Duncan vs T7 Cailan), Maric's Blade is mediocre (probably better when I upgrade it), but Cailan's armor seemed alright. Will upgrade that too, however. Also found some gloves with "Rapid Aim" on them, which is odd because most archers use bows with "Rapid Aim" on them.
I just found the whole experience underwhelming. The Ogre at the end was "Orange", yet I took him down with ease (and my Alastair/Zevran were not well geared, and my Warden set could do with the WK upgrade). Duncan's weapons were really nice, and I'm going to get them enchanted when I can.
I was annoyed by the number of locked chests, however. I don't have Leliana available (I know, stupid mistake) and Zevran isn't able to lockpick (no points in it), so I'm out of quite a bit of stuff. I'll probably find it better on my Human Noble (almost full lockpicking on Leliana, if not full) and my Rogue. Didn't see a single bit of mage gear, either. I bet most mages are fuming (I seem to remember one of the swords being heralded as the best AW sword, and I must confess I didn't look too hard at the ones I found).
And what in Fereldan was with the Zevran disapproval at the end? As thenyxie said, Zevran kept his mouth shut for the whole DLC, but he still gets a disapproval? 'twas only minor (-3), but it was still unexplained and probably an annoyance for those not at the end of the game.
If you like ratings, RtO is probably at a 6/10 or a 7/10. I just don't feel like it made much of an impact, and a some of the gearing didn't make sense.