Two substances, one word
Chimney creosote is a by-product: unburned wood-smoke compounds that condensed on a cool flue wall. Timber creosote is a manufactured preservative distilled from coal tar, sold for treating wood, and subject to restrictions in various jurisdictions. A great deal of the alarming material a search returns, including 'can you still buy creosote' and 'creosote substitute', is about the preservative and has nothing to do with your chimney. Establishing which one an article is discussing is the first step to reading anything about it sensibly.
The risk that matters: fire
Chimney creosote is combustible. The harder forms are dense and burn very hot. It accumulates as long as smoke keeps cooling in the flue, and it does not go away on its own. A chimney fire is that deposit igniting, and it can crack flue tiles and open the joints between them, leaving a path for the next fire to reach the framing around the chimney. That progression, deposit, fire, damaged flue, worse fire, is the reason sweeping exists as a trade.
Handling and exposure
Creosote is a combustion residue and it contains compounds that are irritant and, with sustained exposure, harmful. A practical reason for the containment, filtration and protective equipment a sweep uses, not a reason for alarm about a chimney in your house. For a homeowner the sensible position is straightforward: do not handle deposit without gloves and a mask, do not sweep a heavily loaded flue yourself in a living space, and do not burn anything that turns ordinary residue into something worse: treated wood, painted wood and rubbish all belong in that category.
Reducing it is mostly about how you burn
Creosote forms when smoke cools before it leaves. So the levers are fuel moisture, burn temperature and flue temperature: dry wood, running the appliance in its intended range instead of damping it hard for hours, and a correctly sized, ideally insulated flue that does not chill the exhaust. Fixing the burning reduces the deposit at source, which is cheaper and more effective than sweeping more often to keep up with it.