The user interface for managing is rather crude. FreeCiv has got a much nicer one (but you have many more cities in FreeCiv than colonies in Colonization). That means more micromanagement than there should be.
There are 3 kinds of transport problems:
You are going to need a lot of Warehouses, Wagon Trains (one per road between any two colonies plus a few backups), later some Warehouse Extensions and Custom Houses. Each colony has different abilities to produce raw materials, but they have no preference for kind of industry they support. So try locating iron industry near iron factories and textile industry near cotton plantations. It doesn't mean they need to be in the same city, just don't introduce completely weird setups.
After Adam Smith, when factories get +50% free production, industry needs to be centralized. Factories are too expensive to have only 1 person work in them. Level 2 buildings are quite cheap, so it's not that relevant. Compare 64 hammers + 20 tools for Blacksmith's Shop with 240 hammers + 100 tools for Iron Works. Likewise Textile Mill and Rum/Cigar/Fur Factories cost 160 hammers + 100 tools compared to 64 hammers + 20 tools for respective level 2 buildings (or only 56 hammers + 20 tools for Fur Trading Post.
Trade Routes can help a bit, but not much. Indians and foreign units blocking your roads are also really annoying. Would be nice if some idea of borders was introduced, just to keep others out of your roads (or if the wagon trains could pass in spite of other units being on a road, as long as you're not at war).