Dawn of War is brilliant at least as far as SP goes, very strong campaign. Depends on what sort of scale you are looking for, as DoW has fairly low unit caps and more of a focus on upgrades than some games.
Dark Crusade was good up until the point I got stuck on one mission, I had the best force possible (unit cap maxed, used up, all units with full upgrades etc) and even sending them all in at once I couldn't break down the orc horde. Still got the savegame somewhere might be worth seeing how my current PC handles it (back in the day, it used to slow to about 20fps with such a huge fight).