It depends on both the girl and the piercing
I think that a stud, whether a small diamond or metal ball is sooo hot on some girls (including my lastest pursuit actually), but some just look out of place. For whatever reason I find any other nose piercing than a stud unattractive, and mutiple nose piercings is a straight turnoff