The effect should differ a little for men and women. For men, this sensation might offer stimulation to the prostate as well, giving an extra intense sexual arousement (anal orgasm).
I'm not gay and seriously, stuffing something up my arse is not my cup of tea