Does nose piercing looks good on small nose?

A professional body piercer will be able to consult you on what would look best for your given nose shape and size.