I think a tattoo done tastefully looks fine and rather hot. For me, that means relatively discreet, not shouting out "hey, look at this tat". A small ankle chain or bracelet tat - cool. Something meaningful on the bicep, not bad. When I see one that basically covers an arm or leg, I think it was too much of a good thing, even if the artwork is great. A lot of the time, the color fades and runs and becomes rather dark & nondescript so that I can't tell what the original intent was.
Just as an aside, there was a discussion on another site about a certain striker on an Italian team that happened to wed the ex-wife of his friend & ex-teammate. Bad enough, right? He then gets a tat of his wife and her kids. Just a bad idea all around. Soccer WAGs are rather notorious in their infidelity/longevity. Figured she did it once already.