Do we expect widespread compatibility issues with mods once Dragonborn comes available? Or is the new content fairly isolated?

Speculating won't do anyone much good. Looking at Bethesda's track record with Dawnguard and Heathfire we might expect some hiccups.

Why do you ask?