I used to have over 500 mods active at one time and the game still ran fine, never had any crashes or anything. To me it seems the only thing bad with having alot of mods is slower loading times, and that if one breaks its impossible to figure out which one.