Dear C.,
Do you have any friends whose husbands have had vascectomies? Jeez, I could hook him up with about 30 men to talk to. Trust me, none of their "manly-ness" fell off or ceased to function in any way.
There are men who are "wimps" as you say. But, how typical. A few minutes between the sheets on the right day and a woman endures 9 months of pregnancy then 30 hours of labor and has a kid chomping on her boobies for 2 years. But 20 minutes under a drape in the doctor's office is completely out of the question for the man.
My advice would be to get as much information about both procedures as possible and talk to him about each one. If he wants a sex life as badly as you do, there are some important things for him to consider. Also, if you know any men that have done it and can tell him it's no big deal, that would be great. Sure, they were nervous at first, but once it's done, it's almost like a badge of courage or something. They didn't miss "days" of work. I've been told, personally, by my male friends, that having a wound stitched up was more unfomfortable. Also, they didn't want to put their wives through having to be admitted to the hospital.
Think of it this way, if he is worried about missing work, what about when you are in the hospital and then he has to take care of the kids while you're gone and then home recovering.
Tubal ligation is serious business. I guess it depends on the woman, but you do have to be admitted to the hospital and put under general anesthesia. When you can be released and how long it takes to recover depends on how easy or difficult the procedure is to do. There could be scarring or adhesions from previous pelvic infections, etc.
I'm sure you will hear stories on both sides, either not so bad or really horrible.
I just know that there is a much higher risk of complications for women than there is for men. I ended up in the hospital for 4 days afterwards.
If your husband wants a sex life back as much as you do, he should re-think this and know that by the time he gets up the nerve, it could be over and done with and back to making whoopie!