Snopes.com has more information here: Suffer to Be Beautiful.
It sounds like what you mention is an urban legend for the most part.
I'm not a huge fan of (most) tattoos on women -- any woman (or guy) who wants to look better would be better off getting some exercise instead of whatever else they do to look attractive.
"Tattoo on the lower back...might as well be a bulls-eye"
Wedding Crashers
Snopes - great find! This time it never occurred to me to check it out.