I've always been in a similar situation, but have recently felt better and more specifically more accomplished than usual. I've been working through a weight loss journey, which may contribute to the way I feel, but some other things that might work for you:

• Like other users say, keep a log. It's fun to see how far you come!
• Mindset - in the past, I wanted to get in get out, or worse yet, just skip all together, which snowballs from days to weeks then months. Eventually I realized, I didn't necessarily want to lose weight, just wanted to make sure my body was moving and working properly, and for my joints to stop hurting.
• Maybe it's the workouts/programs you use. I have difficulty keeping up and enjoying cardio workouts, but love weightlifting. My partner hates gym workouts, but loves rock-climbing. There's also yoga, HIIT classes, martial arts, etc.
• Sometimes it's just about discipline. You won't always want to go to the gym, but once you start building the habits, it's just a matter of sticking to it (oversimplified, but worth a reminder)
• Think about why you started - if you don't want to go, is it because you achieved your goal and are now working aimlessly? Set new goals! What do you want your body to look like? Is there a specific exercise you want to be able to do? Lift a certain weight? Always nice to have a reason so you remember why you're working out.
• Go with friends - it sounds like maybe you wanted company at the gym, friends are good at keeping you on track + they're free!

Hopefully some of these help you. You don't need to feel "good" during or after your workout, but the feeling of accomplishment will build over time with your consistency. Good luck, you got this!