Conclusion
GetFormFromFile is bugged.
The first mod that tries to access that missing Mod with GetFormFromFile is fine and works with no problems.
However, the second mod (and possibly any other) that tries to access that missing mod will always fail.
True-life case:
My mods Battle Fatigue and Injuries (BFaI) and Professions affect a third mod, Eat and Sleep (EaS) mod.
Each mod is designed to be installed, activated and to work on their own.
However, if EaS is active, then BFaI and/or Professions calls functions in Eat and Sleep.
If one of either BFaI or Profession is installed WITHOUT EaS, then that installed mod works.
However, if both BFaI AND Professions are installed WITHOUT EaS, the one or the other fails.
Of course, if EaS is installed, any combination of the two works.