While "officially" only the Giant can currently attack walls, gates, ramparts, I think the idea of a Greater Demon or Stegadon smashing walls, etc sounds cool. I'd definately use that as a house rule.
I'd probably limit who/what can attack troops on ramparts based on model size, but having other powerful creatures able to damage structures works for me.