The Professor's (DH) new work study student has a lip ring and a tongue pierce. I have seen them, of course, before, but never before come in regular contact with someone sporting them. They do squicky things to my usually open-minded stomach. I find, after examining my own attitudes, those piercings hard to look at and certainly wouldn't want to kiss them, at least with the jewelry in. I wouldn't say absolutely not, but there would be a discussion, just as there might be over tats I really hated (gross, racist and sexist occur to me; bad art I could probably tolerate.) More intimate area piercings/mods I don't think would bother me at all.
By which I mean, for me, it is going to come down to a matter of A) social convenience (rare, but occurs in places where tats/mods/jewelry (even earrings) are often not allowed in pools, hot springs, or baths, which I love) and/or B) aesthetics, which are quite personal and individual. I don't think there is anyway of knowing what will trip your squick meter or offend your artist's eye until you see it and contemplate getting to know it better. But if tats or body mods are a total turn-off, I think it is wise to say so up front on a d@ting site, or say if yours are extensive or unusual, and discuss the general subject early on with someone you first meet IRL.