I haven't played it yet but apparently this 'Clair Obscur: Expedition 33" is fantastic. I'll quote a friend who just finished it: "Just finished Clair Obscur. Probably not 100%, but I've beaten the superboss and completed the story. It has the exact same feeling as finishing a really good book that makes you feel bad in all the good ways, the kind that has you stare off into the distance after putting it down for the last time."
Personally I feel like I haven't played a great story driven game in a long time. Maybe Baldur's gate 3 could appeal to you. Still not sure it sucked me in as much as Horizon did though.
On a deep sale, the Jedi Fallen order and Survivor are good story games.