You'll benefit the most from taking the extract form of turmeric. That component is called curcuminoid. The standard concentration is 95%. It will absorb better in the presence of black pepper (piperine) usually combined together into a capsule. A good quality turmeric supp usually contains higher amounts of the extract and is reflected in the higher price point. You want this extract because that is the most bioavailable form of turmeric which will give you the most benefits while taking a minimal amount of it compared to just plain turmeric.
If you have not had a positive experience from taking turmeric then the reason may be because your supp does not contain enough extract. There's a world of a difference between versions of turmeric supps out there.