It really depends on the game. I love platformers and adventure games, but I also really enjoy a good RPG every now and then, and most of the ones I play tend to be turn-based. Often times, the story keeps me going as a driving force, and I think it's a bit satisfying to do resource management and see your skills and abilities grow based off of how you do manage yourself. It's nice to see the number of damage you do go up, and it's sort of a simple reward sometimes.
I really loved the first two Paper Mario games, Super Mario RPG, and I'll throw in Earthbound and maybe even some Dragon Quest games here because those games don't only drive the game forward with story, but humor as well. I was also really fond of Bravely Default and its sequel, Bravely Second. I've gotten bored of Pokemon, but I'd be lying if I said that I didn't find them addictive when I was interested, and I've likely spent hundreds of hours in those games.
There's tons of games I can't think of right now, but yeah, I don't really mind turn-based combat. If the game is fun, the game is fun. Is turn-based combat my first choice? No, but if it works within the game, then so be it.