I've had this test done a number of times on both my arms and my legs. I, too, feel they really aren't as bad as their reputation makes them out to be. There is some discomfort and even some pain, but it happens so fast and then it's over.
I had no residual pain after the test. My first EMG/Nerve Conduction was done after I injured my back and was having trouble with tingling and weakness in my left leg. They did both legs to compare the responses. It was uncomfortable for short bursts, but one the test was over, that was it. It didn't cause my pain to flair or leave me with any lingering pain.
The hardest part, I think, is the time leading up to the test when you're wondering how much it's going to hurt. I hope your experience is as good as the many times I had it done.
Best of luck,