Piercing pain experiences?

I have 2 earring piercings and they really didn’t hurt but I feel like I have a low pain tolerance and I really want to get another piercing. I’ve been thinking about a nose piercing a lot for a year now but always think I can’t because it’s too painful. How was your pain experience with it? I’m terrified of needles but I really want one. Also I want to get my cartilage pierced and really like the bar. Which one did you get and how bad did it hurt? Do you think these piercings are worth the pain level? Thank you.