The most important difference between CSA and CE is that CSA is for the Canadian Market specifically for electronics. CE is the product safety framework for the European market, ranging from consumer goods to industrial products.
CSA Marking is not a legal obligation. The manufacturer may, in principle, bring products without CSA Marking on the Canadian market. In practice, CSA certified products are nearly always requested.