I've put one on a couple different cars. They mostly make it louder and make you feel like you are going faster. Manufacturers claim 5-15 HP gains, but not sure if they just make it up or have some weird test scenarios that make the claim "legal". But the car will not be noticeably faster, the "seat of the pants" gauge will say it's faster just due to the sound.
I would never get it for MPG gains - most think it will make the car faster, not more efficient.
The main reason I do it with knowledge of the above is the fact it's a fairly simple install that I can do, it's fun to work on the car, and when done you feel like you've personalized the vehicle. I like to bond with the cars.