I second the suggestion for Sliquid Sassy! It's one of my favorite lubes.
And, as the previous poster said, you should NOT use a tingling or numbing lube. You need to be able to feel what's happening. If you're in pain, that means something isn't right (not enough preparation, too rough penetration, tenseness, and so on). Pain isn't supposed to be a regular part of anal sex.