I've cleared Dragon Soul on my rogue twice since patch 5.0.4 launched, and I'm still not tired of absolutely crushing the DPS meters. My guild is now employing new and interesting heroic strategies due to my newfound DNS. We're cleaving Morchok and his clone Korhcrom, we're getting the Minutes to Midnight achievement on Ultraxion by default, and we just pulled off a 3-lift Spine of Deathwing. If you've got your Fangs of the Father, you have two more weeks to abuse them.
Everything isn't sunshine and rainbows for rogues in patch 5.0.4, though. Any major patch introduces its fair share of bugs and issues, and Cataclysm's final update is no exception. Our new mechanics still need to have some developer oil applied so that they'll stop squeaking. Rogue DPS is obviously working great at the moment, but that doesn't mean that we can't look for areas to improve in.