I tend to prefer "complicated" games that require some sort of time investment to figure out (once figured out, they don't remain as fun for me), but there is no game I've spent more time on than Factorio, and it's "just" 175 hours over the years, which is very low if I compare it to others.
Summary is, you don't have to spend 100s/1000s of hours in any game in order to fully enjoy it.
However I'm "stuck" playing games with short matches and no long single player games. It's easy to put 5 minutes into Rocket League because it feels like just a burst of gaming but then you can do 20 games in a row and still put in an hour.
I don't even have kids and I have plenty of time so I need to get my mindset under control lol.
TMI here but due to a feeling of wasted potential because of inattentive ADHD (treated but still), I have guilt when I procrastinate and am not productive and long games don't allow me to lie to myself about it, if that makes sense.
Gaming isn't procrastinating on other stuff necessarily, it's just the way I feel often.
Sometimes that's OK :)
Also, I personally find that games like DF lend themselves well to having a podcast, audiobook, or twitch stream open on the side. It isn't like a big setpiece voice acted narrative game that demands your full attention.
Personally, I don't buy games until they're old enough to be on 50% sale and the reviews are in.
If you're interested in reviews and community based around limited time, I'd highly recommend reddit.com/r/patientgamers.