Oh, boy, as an (overly) analytical person, I gotta be careful w/ how much I ramble on this one as it can get real deep real quick… 
It would be useful to describe how I arrived here as useful in understanding my perspective on lifting weights. I’ve been someone all my life that’s enjoyed doing stuff and moving my body in a variety of activities and sports. First time I got exposed to a little bit of weights was college and haphazardly through early adulthood. I realized things like squats made me feel good, made me feel more “integrated” or maybe you could say more functional. I had no influences or real exposure until late 30s a decade ago during the early days of CrossFit, we got introduce more formally to lifting weight and Olympic weightlifting movements. I found those fun, because not only was there a scary aspect of flinging weights around, but there was the whole technical aspect to practice.
What also appealed is that since I do like to engage in a lot of core activities (rock climbing, surfing, triathlons, mountaineering, etc.), I appreciated that being stronger would help with achieving more, having more fun, and keeping away risk of injuries in my main activities. So, you could say that there is an indirect enjoyment of lifting weights because of these primary motivations.
At the risk of getting too philosophical, I would say that’s also why I enjoy flossing. That is, because I know it’s good for me and leads to good outcomes. If I were to be brutally honest with myself, I rather sit on the couch eating chips, donuts, and playing on my iPad. Truly. But, since I can’t do that as I would feel (and look) like crap… lol I choose a different methodology of how I treat my body in order to keep everything in better balance.
I only seriously started training consistently with weights about 3 years ago (re)learning what I thought I knew about the movements, this time with a serious coach. I started the typical Starting Strength LP and after several months got into BBM programming. Since I’m heavily goal-oriented, I made the hard work and constant training more motivational and fun by picking numerical goals and looking for constant improvement. After a couple of years, I casually glanced at records and realized that I was now a contender for breaking some. I used that motivation to start competing in 2019. Previous to this, I had close to zero thought of every doing something like that.
All along, I’ve seen that my other activities have benefited greatly from my strength training, even “off the couch” and not doing them for many months. It may sound silly, but even around the house and normal life, the new strength came in handy to get things accomplished that would’ve before required help from someone else. I guess this all a long way of saying that because of these already enjoyed outcomes and hopefully future ones (health & longevity), the “enjoyment” of lifting weights has come through and continually sustained itself.
If I’m honest, there are times fairly frequently where I dread an upcoming training session. Because, at this point for me, the weights are heavy and somewhat scary. There is a lot of effort involved in my sessions. But, it’s a mindset thing. Yes, there is work to be done. But, that’s what I’m here to do, work. Entropy and all that, you’re either growing constantly or wasting. Sounds a little negative, but I think it’s mostly true with all living things. So, just like flossing, I made it through mindset into one of those things that I enjoy greatly. It’s hard, it can be scary, and sometimes I get negative thoughts. But, I realize how fortunate I am to be able to do this and have a nice functioning body and that changes it and then there is truly a lot of enjoyment to be had when you experience your body doing these amazing functional things with weights.
I don’t know if that was at all what you wanted to hear, but hopefully the ramblings were somewhat useful… 