In my case, that "flapping" sound ended up being a loose or partially broken internal baffle in the muffler. At idle, it sounded normal, but once I throttled up, the exhaust flow made it flutter like a tin sheet. No codes, no power loss, just an annoying noise.