I do enjoy this game and come back to it now and again. I do like my wargames to have a bit of RNG to them; otherwise it's essentially a gussied-up puzzle game, to me. And sometimes I am in the mood for that, but usually just as a tactics component to grand strategy, like Civilization V for example. If I'm going to play just tactics, I want them to simulate the possibility for failure, even if that occasionally means a run of bad luck can turn a whole match on its ear.
That said, I've never been a big fan of linear campaigns, since they do tend to bring things back to the puzzley end of the spectrum. Especially with the carryover mechanics, since that means you can have Pyrrhic victories where you win the map, but at too great a cost to compete further down the line. It's what makes save-scumming a virtual necessity in most campaigns, which isn't something I enjoy since it takes the strategy and basically reduces it to trial and error.
The night/day mechanic also kinda bugs me; not that it's bad, precisely, and it certainly plays a unique role in the ebb and flow of Wesnoth combat, but it really screws with my sense of scale.
What I'd really love, though, is a CKII-style grand strategy wrapper around the basic Wesnoth combat system, with a Total War sense of scale, pace, and morale system (meaning causing morale failure is as important as actually inflicting casualties in the course of a battle, not that Total War's implementation of morale is necessarily sane) while teaking a lot of the combat specifics to fit the overall structural changes. I'd play that shit for days.
I won't hold my breath though, so instead I just play those games seperately.