[KageToraUK]

You're asking about which mods are good for singleplayer. Well, while most mods are meant for online multiplay, you can make your own SP missions (or just have a huge battle) using the GEM Editor, and you can use the models and maps from any of the mods in there. You can either play the mission/battle in the editor itself, or save it and play it in Men Of War (good thing about playing in the editor is that you can edit the battle while you're playing it, and add stuff you forgot about - like repair kits for your tanks).

There is also the Tactical Training Simulator, which is like the Dynamic Campaign Generator, only you get access to a much larger force to use in the battle.

There are plenty of single player missions made by players, too, most of which are excellent and can keep you busy for hours.