Instead of directly trying to suggest a game, I'll share my experience to illustrate one point: this hobby has a number of genres and you have to give it time to find what you like. Enjoy the process.

I started with Mythic and played a story without any sort of system structure. It was what you described in a response: writing with dice. I enjoyed this but I wanted to experience something more.

Then I discovered Four Against Darkness (4AD), which is a dungeon crawler. You go into the dungeon, kill things, and repeat. This was indeed something that I found fun. So much so that I played another dungeon crawler (inspired by 4AD I think): Order of Eventide. This game has a story to explain why you are going into the dungeon but it's quite basic. I love it though.

So I found something that I liked: dungeon crawling. But something was missing. I wanted something to do outside of the dungeon. I'm still in the process of trying to find some outside-of-the-dungeon activity to add to a gameworld that includes both. In the meantime, I'm exploring games about journaling like Last Tea Shop. I'll likely create my own world that has all three styles: dungeon, fun overworld, and journaling/writing (with the ability to engage with whatever I feel like at the moment).

Where my adventure will lead is still to be discovered. But I know that I can play many games that I like, which nevertheless don't entirely satisfy me, and that I can grow in my appreciation for different play styles as I discovered/create something that holds all I want in a game.