Like lots of others who have said both, it really depends on the woman in question.
Sometimes these things enhance, sometimes they detract, but overall I think they're hot.
Facial piercings are a bit extreme, especially lip and eyebrow. I can deal with nose piercings, but only on a good looking girl, otherwise they can end up looking more than a little rough.
Tattoos are the same, on a hottie they can look great, but if they have too many or the girl is a little below standard they just make them look like real dogs.