Hello Malice.
fellow Man here. I read your post and winced a bit because you said a couple of things that will be jumped on and pulled to pieces. Don't take it to heart. I see the process has started already.
Anyway - from my point of view:
1.) If you are really bothered about the pain, ask to have it done under a general at the hospital. I did that, and it was great really. You will get it done by a proper surgeon and you will not feel a thing. I have heard plenty of horror stories about the ones done at the "clinics", and I decided that as Local Anaesthetics don't work so well for me, I would take no chances and get it done at the hospital. I just asked for a general and that was it!
No real pain afterwards or issues. If you are certain you DON'T want more children just get it done. Which brings me on to:
2.) I suspect - and I stress suspect - that your wife is kind of boxing you into a corner by "shooting down" the alternatives. No condoms, no sterilisation, no implant.. Vasectomy for you then.. oh but now she is reminding you about the negative articles about vasectomies, and playing on your fears, so you won't get it done. She wants another baby,this is why she is taking no action herself. She does not want to reduce HER chances. I think if you planned to go ahead with it she would increase the negativity until you changed your mind about it. Then its a case of no contraception at all and then "Oh look! I'm pregnant! - I promise I will get sterilised after THIS one!".
Ok, the second bit is wild speculation, but I am afraid that's par for the course here. (It wouldn't surprise me if you get accused of being EA and controlling at some point) - so I might as well get some "counter-wild-speculation" in now.
Basically, if you want a vasectomy, don't be scared, ask for a general.
Good luck!