I value consistency over intensity. On any given day I'm always willing to make my workout as easy as I need it to be to get through it. The main thing is that I get myself into the gym and do it. I never really dread a workout because I know in the back of my mind that I'm not going to do more than I feel like doing. It never feels grueling because I don't let it. If I ever start to get that feeling I dial back the reps or weight until it isn't any more.
It turns out that for me at least, dreading every workout because I have set the unreasonable requirement that I MUST increase the intensity every single time is the recipe for burnout. You just keep pushing the weights and reps up and up, and the workouts get more and more grueling, and in turn you dread them more and more until you just quit. The way to stay in it long term is to avoid that feeling.
You might think that you won't see any progress doing that, but that's not true. I still lift heavy (for me) weights. I still slowly inch the weight and reps higher as I get more capable and more willing to do it. I've seen slow and steady progress on all my lifts over the last 3-4 years. The main difference is that if I'm not feeling a workout, I just dial it back to maintenance levels so that if nothing else I don't lose anything with that workout. Instead of trying to bench 305 for a few reps I might go back to 225 and do 4 sets of 10-12. Instead of trying to row 235 for 6-8 I might row 185 for 8-10. It's still a workout, but one that's considerably less daunting to me, and if I come to the gym in a better mood next week I can still attempt heavier weights because my muscle won't have detrained. You have to listen to your body and mind and do what you have to do to keep them engaged.
The main takeaway is that there is no point in trying to rush to the finish line because there is no finish line. At no point are you going to be able to say "welp, I hit my goal weight and muscularity. I can quit working out now". Unless you're specifically looking for a very transient state of fitness, you're going to be in this for the long haul. Might as well treat it that way.