Probably the most stable and useful one is CCleaner which is freeware. Other then that, they tend to be almost fictional. Beware spyware that claims to be registry repair software, which is rampant. I have used one other program called registryfix. But honestly, I can't say it has ever done much of anything . The bottom-line is most problems that people attribute to the Windows registry are usually caused by other things [security software conflicts, memory hogging programs - especially security software -, etc.]. CCleaner is a nice way to do some spring cleaning, but other then that don't waste your time trying to find some magical registry repair software. Instead, focus on the individual issues you're expecting it to resolve.

Chowhound
Comic Vine
GameFAQs
GameSpot
Giant Bomb
TechRepublic