I'm not hot on motivation at the moment, and definitely couild do with losing (luckily only) a few pounds, but things that really worked for me in the past, and I'm trying to remind myself of now, is the privilege of being generally healthy, able, fortunate enough to be able to afford to exercise in different ways etc.
It's quite Polyannaish, but it actually came from when I was doing Peloton (I had a free trial on the app during Covid, we already had a bog standard spin bike at home which I used with my Ipad), and one of the instructors said how lucky they felt to be able to teach the class etc. It was quite a mind changer on exercise - instead of thinking 'ugh, must do some exercise, this is hard, I hate it', I started thinking, 'I'm choosing to do this, I'm so lucky that I can, my body is amazing, etc'.
I'd really advise a PT, it keeps you accountable, they'll always push you harder than you would push yourself, but in a safe way (and it's really motivating to be pushed to do something you don't think you're capable of), and they'll create a plan to meet your aspirations.
'Normally' though, in a perfect week I do 2 boot camp sessions a week, at least 1 yoga class, see my PT fortnightly, and try to walk with friends at the weekend, so I'm fairly active. My job is pretty demanding, and I don't manage to get away from my desk as much as I'd like (I used to be able to fit in walks at lunchtime or before work, but they've become much harder to fit in). I finds having sessions scheduled makes me MUCH more likely to turn up, plus I tend to go with friendsw, which is another good motivator.