Only time I use the red thumb is if someone is being an idiot (like the moron from the Gleason ad post the other day). I usually click the green thumb when someone posts a reply I like, rather I agree with it or not.
Overall, I'm not a huge fan of the rep system but I can see why we have it. Doesn't hurt either way.