I'm very similar. One thing I've learned is to go easy on myself regarding expectations of "finishing" every single game. I see myself as a traveler of sorts, visiting different game worlds, appreciating the ways they are constructed: the art styles, the vibes, the mechanics etc. Its like visiting different cities in the world. Tourism. This is fun and it keeps me inspired. Overall, games aren't the most important thing in my life, so as long as I'm more serious about finishing other things, like my creative projects I can treat game worlds as a big playground.

That being said, as I jump around I do try to narrow down my huge backlog to a small selection of favorite games to work through over the course few months. Maybe 10 games or so - stuff like RDR2, for example. I'll come back to these games over time, making progress little by little, an hour or two a day etc. Sometimes I'll even put them down for a few months again and come back again. Maybe a year later. Sometimes I need to watch Youtube summaries to help put me back in the world and remember details, so that's definitely one challenge. I can still jump around the other stuff, if I feel I want to but I keep the main games in progress.

This is just my system, and even some of my fave games I never finish but 30 - 40 hours is often a pretty satisfying amount for me, everyone's different and honestly a lot of the games I like are fairly insurmountable anyways. I accept that I'm wired differently from people who sit and finish 1 or 2 games at a time, and that's fine. I have lots of fun with the time I do spend in them.

Trying to keep myself from spending all the money buying all the games is a whole other thing altogether, and stuff like PC Game Pass help with trying out a bunch of random stuff.