I notice most people are talking about JRPGs specifically, but I still want to shout out the combat in Baldur's Gate 3, since I'm in the middle of playing it.
At first, I thought it was nothing more than another DnD system translated to a video game, and it stings early on since it feels like the game knows all the tricks and you know none, but right now about 40 hours in I feel that the combat is insanely well-crafted. There's insane amounts of creativity, synergy and interactivity with the environments and your class compositions that can be had if you feel like it. At one boss encounter, I feared the boss with one character, which made her drop her extremely powerful sword. I then proceeded to pick up the sword as another character and equip it, claiming it for myself. In the same fight, I also placed a bunch of boxes in front of a door, preventing reinforcements, while my mage teleported up onto a pile of rubble and couldn't be reached by the other enemies.
I thought that was really refreshing and that is likely one of the factors that truly makes the game feel like a "next gen" RPG.
Try being the operative word. Delita is no Hamlet, that's for sure. The best thing about tactics is definitely the epic battles and army customization, but they do a good deal of lore and storytelling through emergent gameplay in FFT, but It basically is about a plucky cast of preteens who fight god storytelling wise.
It's important to keep in mind that these games are made with particular audiences in mind, still. Final Fantasy has always been aimed at teenagers/young adults, so naturally it'll retain many of those themes in the games.
I personally think Tactics Ogre is a better candidate for a similar game that doesn't shy away from more "grounded" fantasy themes.
I also sort of believe there tends to be somewhat of a culture shock when it comes to japanese fantasy games, since japanese audiences by and large seem more receptive of stories that center around young people. This is by no means a rule or anything, but there are plenty of western games that have sort of become staples for more mature stories being told in fantasy games/RPGs. Sometimes it's as simple as not being as easily immersed in a "cartoony" style compared to something like The Witcher 3, even though there probably are japanese games with the same "serious" tone as that game.
Even Final Fantasy 16, which (supposedly) tried
really hard to present itself as more gritty, is still hampered in the west because people still think that the characters are simply too beautiful to be taken seriously in such a setting. (It also sucks but that's a different can of worms entirely)
It's also important to remember that video games are video games, and even though we've seen massive strides in making stories more expansive and important, there's still a discrepancy due to the interactivity still being interwoven with the medium, which lends itself to creating situations like "you have to defeat this level 44 boss with your weapon you crafted in a mini-game to proceed" which, if translated poorly, can shatter the immersion if you're more invested in the story of a game, than the gameplay itself.
I understand being tired of tropes, but sometimes all it takes is something refreshing to be able to look at the tropes from a different perspective. Classics are classics for a reason, after all.