For me, it's a turn ON -- so perhaps it's a "to each his own" situation? (Muscledudes with painted nails fly to the top of my priority list.)
And unlike tattoos (or even bushy beards or shaven pubes), it's a modification/adornment that could possibly be negotiable ("might I trouble you to remove the nail polish for our meeting?")...