I don't know much about the potential health benefits, but it is a very cool plant.
I have one growing in my apartment, and one can do some cool chemistry experiments with the turmeric powder! The molecule that makes the powder yellow is called curcumin. You can use it as a yellow dye, a pH sensor, and it has even been used as a component for a low-voltage organic light-emitting diode.