Steam uses VAC for online protection, not in general. You only get banned if you cheat against other players. Most coop games don't even use VAC and the ones that do have an option to turn it off (dead island). I know several guy who are VAC banned for stat cheating on COD:WAW or MW.
[Edited by madatcheats, 7/8/2012 3:46:10 AM]
--------------------------------------------------------------------------- Better to reign in hell, than to serve in heaven.
I use trainers with my games on steam all the time (online mode), yet i dont use trainers when i play online, only for singleplayer mode and thus far i havent been banned.
--------------------------------------------------------------------------- "I want to play a game"
For years I have also been playing STEAM games in online mode, and I always use trainers. I strongly feel that you are okay as long as you do not attempt to utilize trainers in multi-player modes. Good gaming.
--------------------------------------------------------------------------- -Mistakes- Perhaps your sole purpose in life is to serve as an example to others.
As long the game doesn't interact with any Anti-Cheat-Software you should be fine. For example in Killing Floor you can use the trainer on "Solo" mode. Using the trainer on a VAC active server will probably ban you. Not sure what happens when you use ist on servers with VAC deactivated. Shouldn't ban you but very risky. Even in Solo you can level your perks and work toward your achievements. But sadly the option for the weight doesn't work and you can't super-clip low-ammo weapons like pipe bombs, crossbows, grenade launcher (both), LAW and so on. Or you'll cause a crash.
One time in Dead Island I forgot to deactivate/close the trainer and played a very short time online with unlimited weapon durability but since I always have VAC out in options nothing bad happened. Might have saved my account that day.
To be very sure just generate an offline key for your CH-account, save it in a folder with your trainers and cut your connection.