I think any header will last a very long time and not leak. 3 things that help
- be 100% sure you have the correct gasket for whatever motor you are using
- tighten all the bolts evenly using antiseize on the threads, then immediately after firing it the first time, retighten all the bolts while hot (wear gloves)
- spend the money on ceramic coating, not so much for the gaskets, but for the rust and heat management.
I have used everything from Holley Flowtech, to Summit boxed brand, to FPA, Hooker, Blackjack, Cyclone, Hedman, you name it ...if people take the same care in tightening headers as they do for a head or intake manifold, generally gaskets work perfectly.
Unfortunately, many guys come in and I can see they tightened the easy ones, said good enough on the hard ones to get to, etc, and then wonder why the gasket didn't seal.