Live service games, MMOs, gatcha games, and many hardcore multiplayer games are the worst for this. They love to waste player's time on some repetitive grind because they want players to keep playing their game. They usually have either microtransactions (often for cosmetics) or a subscription.

Personally, I love MMOs, but I try to avoid playing any grindy content (or at least as long as I don't think I'll genuinely enjoy it). So I'll usually play a game for a few months (they're really big games) and then quit for years, if not permanently (I have a bunch of MMOs I intend to someday return to, but have not yet).

Single player games are generally much better at being genuinely fun. Especially story driven games. I also love open world games because you largely get to make them your own. It's perfectly valid to beeline the story missions if that's all you care about. Or you could do just the side quests. Or you could additionally explore like crazy. e.g., with Tears of the Kingdom, you really can ignore most of the shrines and largely focus on the story quests. None of the side quests are necessary, either. You don't have to explore the depths except for a tiny few places for the story. The vast majority of sky islands can be ignored. But I personally had a lot of fun exploring, so I explored nearly everything and loved it (except most of the depths -- they were way too big, empty, and repetitive).

Some people don't like long games, though. And that's fine! There's tons of short or more streamlined games out there that you can have fun with. e.g., The Last of Us is a fantastic one. The sequel is about 24 hours long for the story and it felt like it flew by in the blink of an eye for me cause I was having so much fun.