The best way to become self motivated in working out and fitness is this; only do exercises which are genuinely fun for you.
For example, never do any exercises that you feel like you “must“ to do, or “should“ do, in order to become more “balanced“.
This is why I love powerlifting and hibernating so much, it is insanely fun for me an interesting. What I hated doing in the past was the silly programs, 24 sets of 10 repetitions, five sets of five repetitions, it’s a run