If u ask me the cannon is the worst between the three against units.
The serpentine is more accurate then the basilisk, but the basilisk has exploding ammo... So the basilisk is better, because it has supreme wall destroying power and it's good against troops (although it is most expensive)