This one isn't so much of a funny video game "moment" so much as a good long while.
I was up to the Ghost Gym Leader in Pokemon Silver, and we were both down to our last Pokemon. He had Haunter, and I had Eevee. Of course, my Eevee only knew Normal-Type attacks, so I was guaranteed to lose.