I don't have any personal experience with it. Several of the ladies on my due date club when I had my son had it done and they seemed like it went well for them. I do know one person IRL who had it done and it did not go well for her. I am not sure if her doctor was just not that familiar with the procedure or what the problem was but he tore the tube and she ended up with an infection. Her other side went just fine but she had to heal and go back later to have that side redone. I'm not trying to scare you with that story but it is the only other case I know about. I offered to have it done but my dh was fine with having a vasectomy done.
My dh had a vasectomy after our son was born last year and I am still having mixed feelings about it so I totally understand where you are coming from. I am 37 and have two healthy children and I have one of each and I know it makes sense to be done but it still makes me kind of sad.
I think it is normal to feel kind of sad when you choose to be done having babies and it is certainly normal to be nervous when having any kind of procedure done. Best of luck with it and I hope it goes well.
Amy