Piercings... I don't have a problem with them, if the wearer didn't go completely bonkers with them. Lip piercings aren't my thing, but I could see my wife with one in her eyebrow. (currently has 2 diamond studs in her left ear, and 3 in her right) As for myself, the only thing I'd like to try is wearing a set of these glasses:
http://news.bmezine.com/2004/12/14/pierced-eyeglasses-the-publishers-ring/
But, I've already been told that that's completely out of the question.
Tattoos... Again, no real problem with them. I've only rarely seen any tats that would be considered "obsene", but I have seen a few that were just plain ugly. (I'm talking to you, [REDACTED]... seriously, that "panther-thing" is ugly as hell. One thing to be drunk when you get inked, but make sure the artist isn't, too.)