I’m torn about them. On the one hand they free up the combat design to be as wildly different from the exploration as it wants. Which can result in really creative stuff. Favorite examples are Undertale, MegaMan Battle Network series, and Tales series.
But on the other they interrupt the flow of exploration, the music, you forget where you were by the end of combat and they can be very annoying if they happen to be common or just as you’re about to leave an area. The consolation prize of growing stronger with every battle only helps so much.
I agree FF style turn based combat is boring. I mean games that have an auto button that plays it for you are admitting it.
That’s why I like games that have more creative combat that blends different genres. Undertale has some turn based, some realtime bullet hell. Battle network has a real time grid based with card game elements.
There’s so much you can do but so often devs fall back on choose from menu watch cutscene.