I'm a female and my boyfriend sodomises (the actual term for anal sex) me often. No it isn't gross, as long as you have emptied your bowels before hand and cleaned your anus and after the deed you and your partner both clean your bit your good to go.
It can hurt if your not relaxed, sometimes...