Raiding on a rogue is fun because there are endless optimizations and decisions to make. There is not a moment of mindless button spamming - I'm always planning ahead, paying attention, and making meaningful decisions.
People need to think more about overall class design. Obviously, some fights aren’t melee-friendly, but that doesn’t mean a melee or Rogue can’t do his job correctly. Only people who should be worrying about stuff like that are World Class Speed running guilds, and even then I think that is kind of cringe. Always bring the player, not the class.