The officially prohibits adult content in its terms of service. As a result, most explicit mods are removed within hours of being uploaded. Therefore, creators rely on third-party sites:
Adult mods will not get you VAC (Valve Anti-Cheat) banned. Valve has historically taken a hands-off approach to client-side cosmetic mods. However, if you use a mod that gives you a competitive advantage (e.g., making the Witch transparent or highlighting enemies), that will trigger a VAC ban. Adult mods are generally safe, provided they are purely visual and audio.
By utilizing the Steam Workshop and following community guides, players can significantly extend the life of the game through creative customization and technical improvements.