Default replacement conflicts
Two creators both made a default replacement for the same base game item. Like two different default skins, or two maxis match eye replacements. Only one can win. Keep whichever one you like better.
Recolor packs with shared meshes
A lot of creators bundle the mesh with every recolor download. If you grab 5 recolors from the same set, you've got 5 copies of the same mesh. SimSweep catches this. Usually medium severity because the mesh is identical across all the files so it doesn't actually cause visual issues, but the duplicated data is still wasting space.
Override mods stepping on each other
Gameplay mods that override the same tuning files. For example, two mods that both change how fast sims eat, or two mods that modify the same interaction. These are high severity and one of the mods just isn't working in your game. You need to pick one.
Build/Buy conflicts
Custom furniture or objects that override the same base game items. Less common than CAS conflicts but they happen, especially with default replacements for kitchen counters, windows, and other popular items.