It happens to us all, OP. As someone said upthread, you WILL get a job that's a good fit for you at some point. And the bad ones do turn into stories!
I worked with someone who had once had a diarrhoea accident during an interview - top that!
Ok, I can't top that, but I DID cry during a job interview once. Got the job (for the loveliest person ever. Still a friend 30 years later. Lucky he likes emotional women!)
My real worst one was applying for a job traditionally done by men (I am not one). So I deliberately made my CV quite strident so they'd know I could cope in the workplace. I knew I could do the job, but there was one element of it that involved doing quite complicated equations. I'm not great at maths, but I did know it was only a matter of learning this particular equation, and then I'd be fine. [you just had to do the same equation over and over again, but it was only about 1/10th of the job]
Anyway, the CV worked... Interviewed by a panel of 5 (!!!!), including one woman who fair BOUNCED into the room. Grabbed my arm and said "I LOVED your CV" (I'd put as one of my hobbies "terrorising my husband", i think that was what she liked).
There was a written test. About 15 of us. I'm the only female. It was ALL about this bloody equation. Which I had NO CLUE how to do. I think I wrote "15" or "10 to the power of something" or something.
They called us back in. They told me I'd failed the written part (
). I was REALLY straight with them. And I said 'look, I can't do this NOW, but if someone shows me which buttons to press on the calculator, I'll do it and I'll NEVER get it wrong, because I'll double, triple check it every time because I know I'm shit at maths"
so someone explained it. Possibly speaking in Lithuanian. Still no clue. They invited me to have another go. I sat there for a bit. Wrote a number or two down. He explained it again. Possibly in Greek. I sat holding a pen. The woman who loved me said "could we just give RedHats one more chance?" and one of the other interviewers (possibly wanting to kill himself at that point) just said "No!". He was doing me a kindness.
The woman's probably still more gutted than me that I didn't get the job!