I agree with the opposite of your point that girls with weird piercings is a high turn-off. Just last night I was at a bar with a few friends and the waitress was a cute girl however she had a piercing at the top of the bridge...it totally destroyed her look.
I just got an eyebrow piercing last week and I've had several girls already tell me it's hot. I think if the guy has low self confidence or if he doesn't have the right look for it, then it's probably not gonna be attractive to the ladies
it would depend how many tattoos he has I actually like tattoos on guys but if he's like covered then its a turn off. as for piercings I guess it depends I'm not a fan of big gauges but if he's not covered or in a weird spot its okay.