I've definitely had an ups/downs relationship with working out. I used to run cross Country. Then I got an ankle injury around 9 years ago and basically ruined my running career for years. Slowly gained weight through college and that continued once I started my extremely stressful special education teaching job. I tried to get back into workouts and diets. I had a fitbit years ago that I was obsessed with. An average day was at least 20k steps, good days were 25k steps, my record was 35k in one day. Then I lost the silly thing and lost motivation as Google Fit didn't have the same motivation for me. Then I shifted to dietary supplements and had massive success. At one point I lost about 30 lbs a few years ago, maybe closer to 35, then I gained it all back in basically a year due to stress eating (which offset the supplements). I'm now around 8lbs down from January. Ups and downs...
I understand what you have gone through perfectly, I have been on that roller coaster all my life, my ways of losing weight have been pretty dumb, just by saying that I ate only ramen noodles for 3 months should summarize everything. Everytime I have bounced back.
Fortunately I feel that I have been successful at changing my habits. On july 2018 my weight was 230 lbs. Today my weight is 150. The best part is that I have been going down slowly but consistently. Just by walking 30 minutes everyday I immediately started losing weight. It was very little exercise but at the time it was absolutely positive.
Right now my habits are play a session of Ring fit, Drink 3L of water daily, eat vegetables, fruits and protein every day and weekly I meet with a group in order to just talk. It is amazing the positive impact of talking little things has done to me. Many of my eating sprints were caused by stupid ideas that i didn't let out.
My summary to all of this is that for me little but consistent habits has changed my life. For many years I have tried Big monumental changes fast, that never worked.