>For example, why do some types of cancer account for the majority of cases while others are rare?

Different cancers are not simply different mutations. The same mutation can cause different cancers and the same cancer can be caused by different mutations. Rare cancers tend to be those in tissues/organs that have little cell division, so there is less opportunity for mutations to arise and spread.