Turmeric tastes much better after cooking (as opposed to just dissolving in hot water).
Look up "turmeric tea" - a traditional remedy for respiratory illnesses - this should be cooked, too, not just dissolved. Turmeric with honey in hot water, milk optional.
I use turmeric in many foods - most bean dishes, Mexican and Indian foods, etc.
To learn research-backed specifics I suggest two sources:
pubmed.com (easily searched)
nutritionfacts.org (summaries of peer-reviewed research)