My own little $0,02 and tidbit of experience with this subject (as both a player and a staffer cleaning up the mess so to speak).
In personal RP, with a trusted writing partner, it can work. I’ve been in private scenes that involved this material in ways that supported a dramatic arc, and just like dark RP in general, when done well, with someone you trust, and for a purpose (and I’m not a prude, that purpose can be, to some degree, situationally prurient on top of story-affecting…) it can be memorable.
The two places it is a HUGE gamble:
Written in spontaneous RP with someone you don’t know, or with someone who advertises it as THEIR kink. One of the two characters becomes more an object than a participant. There are games for that, sure, but this can be a severe problem on a game that doesn’t rhyme with Shmang or Shpen.
And group RP, where the content is less controlled by nature.