Depends on where you get it and who you talk to. Each person has a different pain tolerance. Mine is pretty low. In getting my tattoo, I unfortunately picked one of the weakest area's of my body. Really bad choice on my part. Since then I have researched. Your limbs are one of the best choices. Just think of which area on your body is the least sensitive. Getting drunk can sometimes help, but I don't entirely suggest that.
Also different methods of getting a tattoo can differ the pain amount. There is one way of using a sharpened stick. Honestly, I like this method. But there are others like the tattoo gun commonly used in the USA. I don't like this method. It sounds like a teeth drill that the orthodontists use. I hate those and have a phobia of them from childhood experience, and it doesn't help that orthodontists love me. So that method, though safer, is not one of my favorites. There is the self tattoo, which I have a hub about, and that is a decent method if you are OCD (like me), but it doesn't look as nice and takes a lot of time. But you can control the environment and pace better.
Etc, etc, etc.