If your car has had the PCM update then it
can pop and bang in normal mode if you build up the pressure etc.
It'll pop and bang in sport mode all day long in Sport - I rarely use Normal Mode (but down the country lanes I prefer Track but with the suspension set to normal as the 4wd is configured better to how I enjoy it) and have never used drift mode.
The exhaust valve in "sport" gives you the pops.
It's a gimmick at the end of the day. Sport just makes the throttle linear instead of progressive and over-fuels a bit to create the pop.