Both my dad and my husband have had them. My dad likens the pain to labor pains. I've never seen him agonize over them. He tends to be the stoic type. My husband, on the other hand, was positively crippled by the pain. He would just fall to the floor and curl up in a fetal position and then stretch every which way in a vain attempt to find a comfortable position. The pain was so bad that it made him vomit.
I would recommend drinking as much water and cranberry juice as you can. And don't get the mixed cranberry juice. If you can get 100% unsweetened cranberry juice, that would be the best. Be warned - it is
extremely tart. Try to stay away from caffeinated beverages and dairy products, at least until you see the urologist. Some kidney stones are calcium based.
Did you get the cone when you went to the doctor? If you did and you can, save the stones if you pass them. That way, the urologist may be able to tell you what it's mostly made of and make a diet recommendation to help prevent the formation of new ones.
There are many different types of kidney stones. You may find this link interesting (or just downright scary):
http://www.herringlab.com/photos/2/index.html
I hope you're feeling better soon. I know it's not a fun thing to go through. Keep us updated on how things are going!
I'm not a doctor. I just play one on TV.