Rectal prep

so i'm having a colonoscopy tmw and the thing i'm most afraid of is the enema.

but i'm thinking about all those porn stars and think they must be doing it like every work day so it must not be that bad?
does it burn? do you get used to it?