Most of people do genital piercing to stimulate sexual sensations, while others see only aesthetic meaning in it. As for female piercing it differs according to the results you would expect from it. There are two main types of hood piercing, the vertical clitoral hood piercing and the horizontal clitoral hood piercing. As the name indicates, the difference is in the direction the piercing is oriented in the skin above the clitor. Neither of these piercings penetrates the clitoris itself. Vertical hood piercing gives you more sexual sensations and stimulates orgasm. Horizontal hood piercing is not that sexually stimulating, it is mostly for decorative purposes.
Princess Albertina is a female genital body piercing, where a ring enters the urethra and exits through the top of the vagina. This piercing requires the bearer to have a large enough urethra for it to be viable. This piercing can be extremely sexually stimulating, as its presence stimulates the nerves of the urethra during intercourse or masturbation.