Working on it still, for now I'll give a small general summary:
Smithing related mods tend to cause issues and crashes, especially with other modded items and usually when picking them up.
Mods that add fauna tend to be laggy as shit, not only due to probably non-optimized code but because they tend not to balance spawns too well. The dinosaur mods I posted for example, there's one (or more) that add medium size dinosaurs that run all over the place (pathfinding or at least the AI constantly working more than other animals) and spawns dozens of them at once. So not only do you have something constantly moving, constantly "working," but tend to spawn in packs of dozens? I'm grateful the ones I'm thinking of are not hostile, imagine this but with Troodons so they're constantly trying to pathfind towards
you?
Primitive Survival is a very well known mod, but how many people know that it has (or maybe had) an issue with
stairs? Apparently even vanilla PS has too many stair variants that causes memory problems. On small, if not PS only modlists, it's not too noticeable. But mods that add materials can cause PS to add more stair variants, which means more memory usage. This is mostly important for loading worlds from what I can tell.
World generation mods, but even then I get mixed results. There's one called
Conquest Landform Overhaul made by the people who made the semi-famous
Conquest Reforged mod and TP, might cause lag but again I'm getting mixed results depending on mod combinations, my guess is that the more mods you have that add more flora and stone types to generate-maybe even biomes-the worse it might get.
Music or general sound mods, "old" (not sure how old) PCs may have some issues, only ones I've been told were Salty's
Cave and
Forest Symphonies. Though it might just be those two mods and how they're implemented.
Better ruins is a known one, not
too sure how much lag and spikes it may cause but I know it does cause some, especially when loading chunks, hell even unloaded ones. Probably to do with calculations.
Having a bunch of small mods at once, you'd be surprised how less than a dozen mods can cause big lag spikes. I'll have to run a ram and CPU monitor and mess around with only a few mods-if not one mod- at a time and see if there's anything to note.