Depend on size - smaller scale adventure might better of from being integrated into the main story - and perhaps it can bring some new neat items that can bring some value to main campaign as well.
If it's a bigger expansion, then separate campaign might be preferable - in vain of Mask of Betrayer
