Depends on a lot of factors, though. A friend of mine put headers on his 65 Mustang, and gained some fuel economy. (It went from "unbelievably hideous" to merely "awful".
)
Any potential gains are probably a lot smaller for more modern cars, though. I'm guessing much or most of the FE benefit for him was the stock system having a pretty poor design.
-soD