In my experience, I have found that eventually there is the medication that seems to be just for you and you will feel like you now have a 'magical' medication. But stay in contact with your doctor. If your doctor is a General Practioner, you might find better guidance with an endocrinologist or a diabetic specialist. I stayed with my usual doctor for a number of years and became so frustrated with many little things that I finally did the research to find a diabetic doctor in my area. In my first visit, she changed everything and guess what !! Everything changed. Now I have great numbers, a 'magical medication.' and am no longer frustrated.

It's a case of deciding if you can live with the side effect or not.I have stopped a number of meds because the side effects - to me- were worse than what the meds were supposed to help.There is always another med.
I trust my own judgement so I act first then tell my doctor.Would recommend making notes of side effect and talking to your doc

Just about every Diabetes Medication can be changed out for something else - most times

Metformin can be replaced with Long Acting (Basil) Insulin - no, no other pills

All of the bunch in the same Family (GLP-1 Agonists) like Ozempic, Rybelsus, Victoza and Mounjaro (plus the others) could be swapped out for DPP-4 Family (Januvia or Tradjenta) and either could we swapped with the available SGLT-2 Meds like Jardiance or Invokana - some are pills some are injectables

And all of them could be replaced by Bolus Insulin or Mixed Insulin

There is always choices

But typically the Doc will prescribe the one with the "least" side effects "first" so swapping to another prematurely may not be the best move

Starting a new med or increasing the dose can cause side effects for a couple of weeks. Some just can never take a med but that is generally less than 1 in 10 that are prescribed