Here are some general threads you might like to check out. If you have any other questions, as someone with nipple piercings and an ex body piercer, I might be able to offer extra advice :)
Nipple Piercings
Piercing Advice
To answer your points:
1. Does it hurt incredibly or is it bearable? Bearable. Of course it does bloody hurt (you're putting a needle through your nipple!) but it is bearable. I had both of mind pierced in one sitting. Do NOT let them using numbing though. It will make the piercing slower and the healing take forever! There is also a risk of frost bite, damaging nerves or even LOSING your nipple if they freeze it so don't be tempted!
2. Whats your thoughts on nipple piercing? I used to have both of mine done and loved them. Took one out this year due to it never healing properly.
3. Does it look sexy? In my opinion yes, but of course that it entirely subjective. What is sexy to one person may be offputting to another.
4. How long does it take to heal? FOREVER. You can ask your piercer to change the jewellery after 6-8 weeks, but 10 years on and my retired one still hadn't healed, and the remaining one still needs regular cleaning. Mine were always aggrevated by bras and nipple play, which was highly frustrating.
Key pointers to make sure you have the easiest piercing with minimal healing time:
- go to a reputable body piercer who uses needles/blades (cannot stress this enough) and not a gun. (Believe it or not... some people WILL try this!!)
- do not have the piercing numbed. This extends healing dramatically and it really isn't good for any part of your body to be 'frozen' in this way.
- the initial bar should be at least 14mm in length (depending on nipple size) to allow for swelling.
- opt for a bar / barbell when you get pierced, not a ring/BCR. A ring will extend your healing period A LOT! Once it's healed, change it to anything you like!
- only titanium, PTFE/Bioplast or Blackline jewellery should be used in an initial piercing. Don't be fobbed off with stainless steel, gold, silver or anything else.
- clean regularly with saline / weak salt water (but don't overclean. 3 / 4 times a day is good)
- wait about 2 - 3 months before you even think about changing the jewellery, and even then, "play it by ear".
- when they've healed, only use water-based lubes for stretching and play. Oils and other creams could aggrevate the piercing.
- if you should end up with any complications (infection, soreness etc) don't be tempted to remove the piercing. Clean it with salt water and take Ibrobrufen. If it persists, visit your GP for antibiotics. Removing the piercing will only trap the infection making it more difficult to get rid of. Leaving the jewellery in gives your body a place for the infection to escape through.