Just thought I'd mention that I now have working plans for a tnt cannon with a 400 block range (in a straight line, slightly more if set up as a mortar). Basically, I've been trying to design the most efficient cannon possible for when someone gets promoted to engineer and we can work with tnt. With all the wonderful components available (most notably wire) an extremely compact and efficient cannon can be made. Instead of the classic long water trench+ timing system+booster setup the charge is stacked vertically. This eliminates the need for a booster (in a normal cannon the booster goes off just before the charge, to compress it next to the shot for max power).
400 blocks is a bit excessive, I admit. However, this is with a 30 tnt charge. The more practical model I would use for raids holds 10-charge and has about a 150 block range, gaining about 10 blocks of range for every 1 block it's elevated above the target. The whole thing takes less than 60 components and can be built in under a minute. Fine adjustments in range can be made by adjusting the timer (just a single repeater) charge amount and elevation of the shot from the ground. Just thought I'd share.
EDIT: After further testing, it seems you only get this range if firing to the north or west. South and east barely makes it 20 blocks. Must be the falling object direction bug...