My nose is pierced. I just wear a tiny stud with a diamond. If you could stand the pain from all of the things you mentioned, this is a piece of cake. I also had babies without pain killers and have my ears pierced numerous times, including the cartilage.
It stings just for a second and it will automatically make your eyes tear. You have no control over it, it's not from the pain. I swear to you, for me, it healed the easiest of any piercing I had, and there was very little pain. Make sure you have it done at a reputable shop, which I'm sure you already know.
Good luck, I bet it will look terrific. I love mine and I'm 47 y/o.