Advice on bariatric surgery?

I think I spelt it right. I am 4’11 and about to hit 200 pounds so around 40 BMI I have tried keto, Mediterranean and the usual counting calories but nothing seems to help. I have had blood work done nothing is off other than going into menopause early. I gained almost 100 pounds while pregnant 5 years ago and haven’t been able to get it off mostly due to a knee injury in which I can only walk short distances.
I have tried the injection we don’t speak of but it didn’t work so well. My question is any advice for going down the bariatric route? I meet the BMI requirements but I’m worried about it not lasting my doctor said 30% of people gain everything back. How was recovery? Does it beat the side effects of the shot?