I've had experience with nose and navel piercings, neither on hurt. The nose one just makes your eye water on that side lol.
I have a tattoo on my ankle. Hurt a little, more an annoying scratchy feeling than pain.
Everyone's pain threshold is different, unfortunately, the only way to tell if YOU can handle the pain, is to go get it done.
Piercings are over with quick, but can take a while to heal. If you go the tattoo route, just get a small one to start, to see if you can deal.