I haven't tried CBD but I know there are many types on the market that are no more than snake oil. To be effective I guess it has to be very high quality and high potency. One of the issues with these products is there's really no regulation whatsoever so anyone in a legal locale can manufacture it in their garage.
I hear people rave about it for certain ailments. I get great relief for arthritis in my hands from vaping medical grade cannabis oil but it's also very high potency THC. Doesn't help at all with nerve pain from my messed up spine but like you said...after a while I don't really care anymore and I can sleep.