Multifoils like SuperQuilt are becoming more popular for insulation applications. Because of their high vapour resistance attention is needed, when installing such layers to standard roof structures, made of timber.
Good air tightness is not dependent to a certain brand or product - the secret of how to achieve air tightness values for nZEB or even Passive House standard is the overall strategy and quality of workmanship.