As a roguelike fan, I LOVE turn-based combat - when it's done right. Sure, if you give millions of healing potions and let us to save at any point then it will turn into a mindless "hit hit hit" slog but it's not intrinsic to tb games.
For modal combat, NO-SKIN is really, really good, and I enjoyed my time with Osteoblasts and Darkest Dungeon too. There are plenty of ways of making tb combat fun and engaging, I wish there were more good examples though...