I think the key to a good medical experience is relaxation. Sure, the procedure might hurt, but it won't hurt forever, so don't worry so much! And even if you're not mentally relaxed, relaxing your muscles makes a huge difference. Do some deep breathing before you go in, and remember that everything will be fine eventually.