The best place to use cannon imo is at troll generals. No wasted shots on rats or bats or anything you don't want to hit. So no wasting cannonballs to hit a 1 or a 2.
I'm sure others would have other opinions. I just don't like it when people come into a popular area with a cannon. So I try not to be one of those people.