Minecraft.
Way back in its beta days, a couple of mates couldn’t put it down. They couldn’t explain why digging holes was fun nor placing cubes. I really didn’t get it after a demonstration from them. Eventually had a LAN with a mate that was vaguely curious but also didn’t think it was going to be interesting.
We didn’t sleep for the next 36hrs, nor notice it was a new day until my family got up and started making breakfast.
Fully the same here. Sometimes I get bouts of inspiration to hop on the server or organize to do something with the group we have, but always fizzles out after a few months as you say. Which is fine really, a lot of other good games I tend to circle back to over time just like minecraft.