It's definintely a good spice to have in the kitchen. I keep a stash of fresh turmeric in my freezer and when I feel hardworking, I would blend it with a bunch of other spices to make my own fresh curry. However, you can also buy curry powder to make curry--it already has turmeric. You can also use turmeric powder to marinate meat or fish. It gives it a nice yellow color, plus, it's very healthy. Simply mix a teaspoon of turmeric with some salt and season food--that's the simple way. There are other ingredients you can add to turmeric to make a good seasoning blend e.g. coconut milk, cayenne, honey, coriander, salt and fish sauce to make satay (commonly served in Thai restaurant). In Asian cuisines, it is also added to soup to give a nice color. You can also use it in stir-fry.
Other than food, some people use turmeric (especially blended fresh ones--they're called yellow ginger in my culture) as a face mask.I've seen Indian woman walking around with a yellow tinct to their face--I've been told they use turmeric. I'm not sure why--I think it's because of its antiviral effect--to treat acne, perhaps.