Oh, ok, I don't have many experience with mod since BG1 times (yes, about 1999 ) and I back in the mod "mood" just with PoE2
I don't know how Skyrim or other game mods work, but I have taken a glance and tried some nexus and steam mods and I can say that it is all about the developer of the mod. You can find mod which really change a little bit of the game (i.e. one or two weapons or equip) and put only a little file for the mod with quite no "dispruption" for other mods, and the SAME mod can be done changing a big unique whole file which will conflicts with every other mod that touch weapons or equip.
So, I doubt you can find any guide or whatever about mod loading and priority because it should mean that a people before you have tried all the mods you wanna install and say "this one can be loaded first, this one after the first, this one instead is not compatible with mod A, B and C"... and so on for 80 or 90 or 100 mods... it is because of that I said "there's no way"... maybe someone did it and I don't know, but the best chances are:
"major" (you can read "most popular/most used") mod can be loaded with each other and, in the case, in the guide there are list of compatibilities and load priorities;
mods from the same developer are compatible (at least, I hope!) and in the case he/she provides list, guide, priority etc...;
little mods can work with major, maybe dev have tested them, maybe it used to work a day but then there was a change in a major mod and dev of the "minor" mod didn't fix issues ... in few words: you can make any assumption until you don't install that mod with others
Let us know if you find something, but for the reasons I'm saying I think you have little chances...