We never had any detection since release on Modern Warfare. However you can still get manually banned for playing too obvious.
And no cheat is undetectable. There is always a risk of a cheat getting detected.