If a dragon break occurs, does that mean all mods taking place within the time of said dragon break are automatically considered cannon?

Mods? Do you mean DLC? The stuff released by Bethesda?

All community made mods are going to be considered non-canon regardless.

I doubt it. They are user made content, not anything from Beth.