I am "only" a dozen+ hours into Clair Obscur, and I am similarly not understanding the hype. Combat is too gimmicky and annoying. The story is tonally all over the place. It starts out very dark, and then the characters seemingly have no problems going on stupid side quests because they want to see some cute elves or something. Are you saving the world or not?
The joke side quests work in your standard RPG because they take themselves less seriously. Your character is wielding an eight foot sword, the mage companion is a talking cat, and your boots are haunted by a long-dead Egyptian prince. Sure, go nuts if you want to play the mini-game at the circus belly-dancing competition to win the golden hat.
Clair Obscur starts in such a bleak, breathing world that the characters not treating the situation deadly serious breaks my connection to the world, so I start to focus more on the mechanical annoyances.