Currently I like demos overall well roundness in not only raiding, but in various PVE activities including questing and five mans. Destro is my next with my only gripe with it is lack of mana management besides limit of fel fire which just feels dumb. I used to be a big fan of Affliction, but that was in Classic and BC then came in haunt and making the aspect of multi dotting ether underwhelming or far more of a burden especially in dungeon environments.
I personally enjoyed it far more than what Affliction was turned into. DL was a nice change of pace and with it came even better survivability and now I feel like a shitty shadowpriest.