Doesn't really phase me but I find belly button rings to be a turn off.
From a purely aesthetic point of view I find that piercings are like clothing. They look good when somebody wears piercings that compliment their features.
If I were to generalise I would say that I do find them attractive. But I am a body piercer and am also quite modded. I have my lobes stretched to 40mm, my labret stretched to 10mm and my nostrils and septum stretched to 5mm. Plus six dermal anchors on my face and some other stuff that is probably inappropriate to get into detail about in this environment. So I am pretty biased regarding this subject.
Anyway, depending on the person I find piercings, tattoos, implants and even heavier stuff like ear pointing, tongue forking and navel removal attractive. The only thing I'm not into that's above the belt is nipple removal. Having said that, I fully support people who choose to do that and many other things I wouldn't do.
I don't have a problem with ear piercings or nose piercings, so long as the nose ring isn't very big. I would date a girl with either, and I while I don't have any piercings currently, that doesn't mean that I won't some day.
I draw the line at huge holes in your body… in other words, stuff like this: