What a lot of them do is they tell Windows they are using ridiculous amounts of RAM which cases Windows to ship data off to the paging file to make room for the RAM booster. The booster then gives back its memory and, in theory, you have free physical memory.
I have no doubt some tools are useful for optimising memory, but the majority of them don't really do anything that Windows couldn't do normally.