Kjane - I had a TT back in 2002 and despite the recovery, which was basically two weeks in all, it was very well worth it to me. I have three children, but my body was basically screwed after the first. My skin never bounced back and no amount of exercise was ever gonna fix it.
In regards to the pain, it is really just a distant memory for me now. But I won't lie, it's not an easy surgery to recover from. But, the most miserable thing about it to me was the drain. I did SO much research on TT's before my surgery, but did not know where the drain would be put in. Well, turns out it's in your pubic region (unless some PS's do it differently). And during the recovery, I kept accidentally pulling the tube which caused a lot of unneccesary pain. Once the drain was out, things got better. I remember being scared that I would never be able to stand up straight again. You have to allow time for that.
I could never fully explain the procedure without screwing something up. My best advice would be to pull up any and all info you can from all the many web sites and they explain it in full detail (give or take information about the drains).
But, like I said before, it was so well worth it to me. My clothes fit right now. I don't have that bulge anymore. My stomach is nice and flat. I have to live with the scar, but am planning on having some laser surgery soon to help take away the redness so it is not apparent.
Hope that helps some! Good luck!