You're not taking into account rogues utility though, as well as the fact that on a lot of fights it's boss damage that's the most important. Logs on first 3 aren't really relevant as they are free kill bosses, so we have to look at the last 6. Last 2 don't have enough/any logs but I think just looking at how many rogues were brought to the first kills shows how good they are on those fights. You already showed sisters where rogues were among the top dps, but now lets look at mistress and desolate host which really are all about single target as the adds already die quickly(often too quickly in the case of mistress, as a shadowpriest I often have to not dot the adds at all to be sure they don't die too fast).
https://www.warcraftlogs.com/statist...metric=bossdps here we got boss damage for mistress, while it may be slightly skewed due to rogues having high prio on buffer fish(Try and guess why) they are still incredibly strong here.
https://www.warcraftlogs.com/statist...metric=bossdps and here we got desolate host, pretty much same thing.
Now there are definitely also other good classes/specs like demo locks however they do have the weakness of not having very good mobility nor utility, both which are things that sub rogues absolutely shine at.