Same. I had my first one when I was in another country (fortunately, my wife was from said country and I was covered under her insurance, 'merica!). I thought I had to pee really bad, and the feeling never went away. And within minutes I was on the floor in a ball with tears in my eyes. Because of the way military insurance worked, we had to get approval from the post doctor, who originally told us it'd pass. He called back within minutes and said "yeah no, that's an emergency, get to the hospital now."
That was the day I learned how people get addicted to Vicodin (I didn't, I just realized how great they felt).
Anyway, I've had 12 more since, that I know of. Lots of people form stones that cause no pain. I've had surgery for 4 of them, the rest I just took meds to help pass them faster.
Actually passing the stone from your bladder to cursed "birth" is the easy part, I always say. It's over in a second. The problem ones are when they get stuck in the ureter. One of mine actually got me bumped ahead of a guy having a heart attack. Not sure how that worked. Another one resulted in an infection around a stent, which then likes to move, and feels like a mega-kidney-stone. From what I understand, the doctor who saw me that day was going to escalate because of the total lack of medication they sent me home with (nothing for infection, and a handful of Tylenol 3. For reference, it took 10mg of morphine to effectively manage the pain).
Anyway yeah, kidney stones are literally the worst. My aunt has had 4 kids, and gets stones like I do, and has said repeatedly that she'd rather have more kids. That's pretty damning.