Butt sex???

Okay so my boyfriend and I tried anal a couple weeks ago but I stopped him almost right away because it hurt so bad! I said I was open to trying it again but only if we use a lot of lube and go slowly. Is it really worth it? Does it actually feel good? And what are some ways of making it hurt less???