I.G.
I had a breech baby and a successful version. I also got all kinds of horror stories to hear before the procedure - most of them second hand (or even farther removed), my advice for you is not to listen to them.
After going through the experience myself I would suggest that you find a practitioner who has experience doing them, not someone who would be better served (as in get more cash from you) if you ended up with a c-section. I am convinced that those women who actually had a painful attempt had some kind of butcher who didn't know what they were doing. Even if you don't have a midwife, ask one (or a few) for recommendations who they work with.
The version itself was remarkably unspectacular. The OB who did it let me know beforehand that he would not force things, but rather coax my baby to turn. Ultrasound to confirm the position before hand and see which way she would be easier to turn - plenty of ultrasound gel on my belly to help with turning. The uncomfortable part was pushing the lower belly up to lift her butt out of my pelvis, it a lot of pressure on the bladder - not painful just very uncomfortable, make sure that you pee before the procedure.
The doctor used the other hand to gently but firmly push her head in the direction he wanted the baby to turn. In my case at first the wouldn't budge, second try she moved a little and on the third try she flipped and stayed head down.
I am very happy I did it and avoided a c-section. There is no guarantees though.
Good luck!