I personally used TortoiseCVS lot of times with success but if I was in your shoes I’d prefer using the IDE integrated tools if you use Enterprise versions for programming; anyway the TortoiseCVS is a good system.
Don’t forget to visit my blog: If it has a plug, it’s IT stuff!!
We use SourceGear Vault for our source control. It’s a pretty thin client, and has Visual Studio integration for the .NET developers. As I understand, it is not that expensive either.