I guess I'm really after an aid to help people who forget, Cruise Control sends out the details of commits to everyone, so people are keen to add a meaningful comment, but sometimes forget.
You can write a pre-commit hook that checks this. This requires access to the CVS server.
You will also want a human monitoring the comments that people are adding, though.
Or expect a flurry of "foo", "checkin", "commit", "changed code" comments as people try and bypass your check.
In a past life, we also enforced the mention of a defect/task ID, and checked that ID existed in the task tracking system...
We use Subversion and Tortoise and it is possible to do this.
Basically you need to set the tsvn:logminsize parameter on the trunk folder. This will allow you to set a minimum length for a comment (anything > 1 will result in mandatory comments)
Rather than enforce comments through your CVS, just tell your developers that you may be doing spot checks on the comments, so please put in useful comments when you check in your code. While I agree that comments in the code itself are more useful, sometimes it is useful to know what the purpose of a code check-in was (e.g. fixed a bug in rounding tax amounts on invoices). However, this can be easily abused, with someone constantly checking the comments, which wastes a huge amount of time. This way it relies on the honor system, and the fact that no-one wants to be singled out for not putting in the one-line comment that you requested.