If you just get a regular stage 1 tune and a catback or muffler delete you'll get some random backfires which are a lot of fun. The car will still keep its normal exhaust character.
If you go stage 2 with a header change and exhaust, you'll get a lot more of that, but it will still be livable and not sound like a popcorn machine.
The popcorn tunes on the 86 platform that are specific for making pops and bangs are excessive and take away from the natural smooth running character of the engine. It just backfires all the way down on acceleration. I would avoid, it makes the car sound broken. I'd cringe to death if I was slowing down through a construction zone or a speed trap and it sounds like slapping and banging in the back of the car.