Look into Mounjaro. (I'm not a Dr)
I know a few folks who were on metformin long term for diabetes related things, and after the switch, lost a TON of weight from metabolic changes in just that year compared the entire past.
As with both generally, they're starting to clamp down on prescribing/filling for non-diabetic folks (aka, people using it just for weight and not clinical diabetes itself).