How to detect backdoors?

Never thought of checking the leaks or addons I download from the workshop, your post made me think again on how I deal with custom content for sure. Are they that common though?