I never felt like artillery was worth the trouble, especially on those horrid battles where you have to wheel it uphill through half of the map just to get it into place to reliably knock down a wall. Better off just strafing the walls with gunfire from your infantry until they're cleared of enemies enough to safely use their rope ladders.