So sorry you are having to deal with this, mama....I'm sure it's hard on you in so many ways.
I have seen repairs like yours as you describe it. And yes, it can wreak havoc on a woman's sex life and emotional life!
All I can say is that a repair is most likely the best thing you can do for yourself. It totally sucks that your original repair was done so poorly, but know at least that you can be repaired. And for all that it is surgery, do you really have to be put under for it? I would think that a local would do. And I would think that it would be a fairly simple thing...well, not knowing exactly the extent, not having an actual picture of your yoni, perhaps I shouldn't say that. But it seems quite possible that your repair can be simple and fairly straightforward. Not sure what you've had by way of medical opinions--but you might want to get more than one opinion, so as to make the best choice.
Just know that your feelings about this are quite understandable! And also that even though you shouldn't have been forced to need a repair, many women do have successful repairs in your type of situation.
Be good to you, learn what you can, make strong choices so that you can heal and put this behind you.