Many mods are built using specific C++ libraries. If your computer doesn't have the 2015-2022 redistributables installed, the mod will fail to inject code, causing a crash.
When mods fail to load or cause crashes in Sonic Generations
: The original game uses D3D9, which can crash on newer hardware. Installing the Direct3D 11 Renderer mod via HMM fixes many performance and stability issues. Load Order