I've known three women who had this done. Two of them gained it all back, and one kept it off.
As for looking good, I think that rapid weight loss leaves the face looking too triangular and pointy, and the woman I know who has kept the weight off, still has that triangular look to her face, so I think they don't even "look good" with the surgery.
It certainly improved their energy levels and their self-confidence, though, at least superficially. I am no longer in touch with the women who gained their weight back, but the one who has kept it off still has some serious insecurity issues and her energy is great.
I would hate to have that done, and then gain everything back. Talk about a blow to the self-esteem!
One of the gals who did gain it back, i remember feeling kinda jealous of her, because she was wearing such cute clothes and sparkling with self-confidence...she and I weighed the same when she started...anyway, we went to a church function/banquet where cheesecake was served for dessert. She had already had her two ounces of dinner

but she kept on taking little tastes of the cheesecake, until she finally said "will someone take this away from me? I can't stop and I'll make myself sick" I put a crumpled dirty napkin on top of it and said "There. Now it's garbage, and we don't eat garbage" but she still asked me to move it out of her reach.
so, yeah. I do not believe the surgery really gets to the bottom of obesity. Gluttony is the true issue, and that's a mindset, or a character flaw, not to be cured by solely physical means.