Turn-based can be damn fun, just play XCOM2.
I agree that turn based-games are fun but XCOM2 may not be the best example. I started to enjoy XCOM2 more after I altered some of the code to reduce the RNG. The game played more like chess rather than just me watching it play without me.
As others have mentioned, the tedium of combat can make the game feel like a drag.
