I have a small, discreet tattoo on my shoulder and a breast cancer ribbon on my wrist. I have to admit the wrist tattoo was really painful, but I had it done after my DM died and I then had breast cancer.
Eldest DD is a teacher and has no tattoos, nor does her DH. DD2 has lots, so does her DH. But it's their choice. DD3 has 2 discreet tattoos. My DH has none and doesn't like them.
I often think people will regret their tattoos in later life, but it's been a fashion for almost 20 years now, so all the multi-tattooed folks will grow old together with their saggy tattoos! I personally don't like sleeve tattoos or those in necks and legs, but it's a choice for a lot of people. As to self abuse, I think for most of the young people who get tattooed it's more about fitting in. So many of their peers are tattooed and they want to fit in.