Some of these products do actually make a performance difference, usually by altering the way the system does memory management. However, the performance difference is usually usage dependent so you may or may not see the difference based on what you do with your system.
Having said that, in my experience these programs virtually all cause some instability or other that makes them just not worth it. I wouldn't run one of these for the same reason I don't overclock my systems -- the couple of percentage points of increased performance just isn't worth the increased risk that my system might die at some critical moment, causing me to lose hours or more of work.
YMMV.