For most games, I’m like you - It’s been a gradual shift for me, as I used to play very sandboxy type games before (although I could never get into Minecraft), but have been heavily focused on story-heavy / experience-based games for the last 3+ years.
I will say that I really liked BotW though, and am looking forward to playing TotK eventually (in the next 2/3 years or so) and Starfield has got me really intrigued, so we’ll see.
Then there’s the “intrinsic me”, I guess, I don’t mind playing some games for the sake of it, with no goals in mind - Forza Horizon just going from one end of the map to the other, or the same loop of various arcade games whenever I don’t feel like doing anything else - sure there’s some sort of objective, but ultimately when you’ve seen and done it that many times, it’s not far off from it not being there at all imo, and I still enjoy it just as much.