My tatoo was more irritating to get than actually painful. I kind of wanted to smack the artist and say "cut it out!" I don't regret it for one single minute, and I fully intend to get another one with my daughter's name. I think the people who regret they got tatoos either did not think them through thoroughly, or got something that was only temporarily meaningful. The one I have symbolises the nickname I have had for over 20 years, and the one I am planning is my daughter's name (she's in heaven). Of course, when my son is older and sees I have my daughter's name, he may want me to have his name put on me, and that will be ok, too. I would never put my husband's name, there is no guarantee I will stay with him for my whole life.
One person's humble opinion.