There is no exhaust mod that will cause limp mode or a check engine light without a tune if installed properly. And just to make it more clear "mod" means modification so yes any mod.Depends on what you mean by "exhaust mod". The FKX is the only DP that you don't have to get tuned with. Some people get by without a tune on the RV6 since it's only 2.5 in, but you won't be gaining any power without a tune, so kinda pointless.
Check engine lights and limp mode occur from intake mods because all the sensors that would trip a code are on that end of the process.