Men who got a vasectomy how was the experience and if you regret it why?

Particularly how has it impacted you physically, if at all sexually? My 37F fiance 44M has not been open to the idea and worried about any adverse effects. However he does not want anymore children. We both have kids between the ages of 16-21 and are not remotely open to the idea of starting over. We are wanting to enjoy our freedoms and watch the kids grow up and start to have families of their own one day.

I was refused a tubal ligation by the doctor after my 2nd kid bc they thought I was too young. So I ended up with an IUD that perforated my uterus and required surgery. Was told due to the amount of scar tissue any future pregnancy is risky. I didn't want to have more kids so whatever, but now i have this whole new complication if I accidentally got pregnant when they should have just done what I originally wanted. It still makes me angry to think about! Anyways....

So I did the pill for years but it made me psycho no matter what type. So birth control has always been a struggle for me. I'm hoping shared experiences will help inform him and maybe change his mind. Thank you!

Edit/Update: Just want to say Wow and thank you everyone who shared! And to those comments that felt I am using the internet to pressure my partner...I truly wanted to know others' experiences, including the unfortunate ones to help better inform him. I have read him some of those and when he is ready, he can take the time to read everything on his own. I'm not forcing it at all, but trying to better educate him and myself.