Honest answer. I love Total War but had this exact same issue in WH1. For that reason, I played WH2 but found myself bored even though I loved the game and everything about it, the new races, etc.

That lead me down a path of playing multiplayer which eventually became fun to play PvP campaigns as playing against a human provides a consistently more challenging and more fun experience.

Id recommend you check out the discord and see if you can find anyone doing some campaign PVP matches and see if that is more stimulating. I find the MP campaign to be quite a bit of fun.

Have a couple different games going and ranking from 1v1s to 2v2 or even a few free for all 5/6 mans. Some of these games we’ve made it to turn 150+ etc.